Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 MS SQL 2000 Command

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-27 : 11:20:24
Choots writes "I am running Win2k Server with MS SQL 2000 SP2.

In Oracle I can do DESCRIBE table_name. This will output all columns and their attributes of the table.

What is the MS SQL equivelant?"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-27 : 11:20:24
The information schema views: http://www.sqlteam.com/item.asp?ItemID=261
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-03-27 : 21:55:19
Or... sp_help tablename

------------------------
GENERAL-ly speaking...
Go to Top of Page
   

- Advertisement -