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 |
|
sumalatha
Starting Member
6 Posts |
 Posted - 2009-03-05 : 06:53:06
|
| Hi am new to sql server 2000.I want to know the command which describes the table structure |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-05 : 07:20:51
|
| sp_help <tablename> |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-05 : 09:02:47
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/28/different-ways-to-know-structure-of-a-table.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2009-03-11 : 02:25:10
|
| hi sumalathaYou can get your table description by typing table name in sql window and select the table name then you can press alt+F1 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-11 : 02:50:01
|
quote:
Originally posted by boreddy
hi sumalathaYou can get your table description by typing table name in sql window and select the table name then you can press alt+F1
It was specified in the above link too  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
table description