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.
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 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-03-27 : 21:55:19
|
Or... sp_help tablename------------------------GENERAL-ly speaking... |
|
|
|
|
|