Displaying table column name and description only 2

[Asif22]

Having used oracle/informix/mysql where u can just describe the table ie. desc <tablename> to get a summary of just the
table columns; How do I do this using T-SQL ?
It get's a bit troublesome having to go into Enterprise Manager to display graphically the descriptions.

I'm trying to utilise isql to just display column description of a tablename.

Thanks in advance for any help.

 

[chiph]

Try this:

SELECT c.name
FROM syscolumns c
INNER JOIN sysobjects o
ON c.id = o.id
WHERE o.name = 'tbl_tablename'

Chip H.

 

[tlbroadbent]

Try sp_help.

exec sp_help 'dbo.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.

 

[chiph]

Thanks Terry. I came from an Oracle environment, and I've been amazed at the lack of &quot;helper&quot; views and procs in MS SQL Server. I guess I need to be more creative in searching the BOL.

Chip H.

 

[KRISF]

sp_help is the best.

Micorsoft does not recommend referenceing the sys tables. Instead use any of the INFORMATION_SCHEMA views for this purpse.