How can I list columns in a table?

[gArmitage]

Hi,

Does anybody know how I can get a list of all the columns in a table? And then get the attributes of those columns?

Many thanks,

Grahame

 

[WildWill]

This should do the trick:

select * from syscolumns where id =
(
    select id from sysobjects where name = 'myTable'
)

X-) Billy H

bhogar@acxiom.co.uk

 

[gArmitage]

Thanks - I'll give it a go.

 

[xcata]

Hi,
The preferred way is to use the the information schema views
because system tables may change
ex:

select * from information_schema.columns

here, information_schema is the owner and columns is the name of the view. The are other interesting views to interogate and they are all contained in the database model so when you create a new database you'll have them.