sybase newb...

[SpreadTooThin]

I'm trying to figure out the column names in a table...
I'm use to SQL and saying something like DESCRIBE TableName;
What is the sybase equivalent?

[b***@msn.com]

Post by SpreadTooThin
I'm trying to figure out the column names in a table...
I'm use to SQL and saying something like DESCRIBE TableName;
What is the sybase equivalent?

For ASE,

execute sp_help TableName


or for a more raw view of the data, just the column names

select name from syscolumns where id = object_id("TableName")

[SpreadTooThin]

Thank you very much.
name is one column but are there others that might help me determine the structure of the table?

[SpreadTooThin]

found this...
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.tables/html/tables/tables22.htm