Describe table

[pdbowling]

Hello, Everyone.

When I used to work in Sybase, they had a function called Describe (utilized Describe myTableName) that would show the column names and data types of the table.

Is there something similar in SQL Server 2008? I googled a bit but everything seemed pretty complex.

Thank you,
Patrick

 

[MarkSweetland]

[bold]sp_help tblTableName[/bold] will get you what you're looking for...


Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[simian336]

select * from sys.columns
where object_id in (select object_id from sys.tables where name='YourTableName')

Simi

 

[pdbowling]

Thank you so much.

That is poetry.

Patrick

 

[philhege]

Or

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName'

-----------
With business clients like mine, you'd be better off herding cats.