i'm working on an sql server.

example: i got a table "user" with columns "usID","usNAME" and "usPWD"

i know it works, but i don't know the sql statement to SELECT all the column names of a specified table (here: "user")

SELECT * FROM sysobjects WHERE type = 'U' - with this statement i got every table in my database.. so i think it will work in a way like that..

do you have an idea?

thanks

The syntax is the same as what you had before but instead if the * character (which means everything) you just specify what you want

Except without the quotes around the table and column names. So if you want all the columns in the table "user" then do:
SELECT * FROM user

and add a WHERE clause if you like, and whatever else.

example: SELECT * FROM sysobjects WHERE type = 'U'  returns a recordset that consists of these entries:

name
----------------------
User
Articles
Links
Comments

so out put rs("name") while not EOF is "UserArticlesLinksComments"

- the table names in the database...

and if "user" consits of the attributes "usname, usid, uspwd" i want to have a sql query that returns

name
----------
usname
usid
uspwd

understand now?

btw... i know sql pretty good... but no idea about that...

(Edited by Quentin at 10:13 am on Dec. 13, 2001)

interesting. I've never done that before. I'll think about that... just out of curiosity, why would you need to do that? don't you know the names of all your table columns?
(if you don't, I worry about the application... ;)

for example a data-manipulation-file... select your table, enter a sql statement and execute it... or list all your data of 1 table with input fields for editing... would be a 100% dynamic story to edit files with a database...

:)

i think i'm pretty sure about what i do ;)

like the snitz forum or the comersus e-shop...

just the sql statement would help me more than a whole finished product...

but it's a good idea, i'll have a look...

SHOW COLUMNS FROM tbl_name [FROM db_name] [LIKE pattern]

I hope that helps, I put a sticky on the page if you need more info.

Peace,

stay tuned ;)