syntax help? describe a table

[TWillard]

I am new to SQL Server. However, I do have some database experience with Oracle. I am trying to describe a table in SQL Server. I need to now the column names of a table using sql syntax, as opposed to using SQL Server Enterprise Manager. If I at a sql prompt for an Oracle DB, I would type: desc table_name;
Does anyone know the syntax for this command for a SQL Server Database.

Thanks in Advance!!

Tim

 

[tlbroadbent]

Use sp_help 'tablename' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[RickCole]

Try

sp_help tablename

Rick.