Is there a way of listing all column names in MSSQL for a specific table, something along the lines of:
select * from sysobjects where type = 'U' order by name
Which would list all user tables in MSSQL database ?
select * from information_schema.tables
The views in the schema information_schema are defined in the ANSI SQL standard.
Excellent, many thanks.
Now that I reread your question I see that a more apropriate answer is
select * from information_schema.columns where table_name = 'MAGDUR'
I had figured the last bit, as without it, it wouldn't know which table to list the column information from.
Thanks once again.
