Describe a database

[cphill7292]

In Oracle there is the commmand desc which is used to describe all the colums in a specified database. My question is, is there a similar command in SQL Server

 

[SQLDenis]

look at the INFORMATION_SCHEMA views
or at syscolumns (Contains one row for every column in every table and view, and a row for each parameter in a stored procedure. This table is in each database.)


“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[yelworcm]

That or sp_help table_name does much the same thing.

 

[icemel]

I use sp_help 'tablename'

That will give you a listing of all columns, indexes, etc for a given table.

Also, select text view instead of grid view when running this, easier to read.