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 |
|
xman
Starting Member
3 Posts |
 Posted - 2006-04-03 : 04:31:00
|
| I needs to find table defination in sql server 2000 using sql command in query analizer.How could i do this? |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-03 : 04:35:04
|
| sp_help-------Moo. :) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-03 : 04:48:58
|
| or hightlight the table name and press Alt+F1MadhivananFailing to plan is Planning to fail |
|
|
|
xman
Starting Member
3 Posts |
Posted - 2006-04-03 : 05:10:58
|
| Thank you. It works. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-03 : 06:33:04
|
quote:
or hightlight the table name and press Alt+F1
Aha That was new to me too..Are there any more these kind of short cuts??If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-04-03 : 06:36:46
|
refer to SQL Query Analyzer Keyboard Shortcuts in BOL
KHChoice is an illusion, created between those with power, and those without. |
|
|
|
Pat Phelan
Posting Yak Master
187 Posts |
Posted - 2006-04-03 : 08:42:47
|
| Doesn't anyone else use the INFORMATION_SCHEMA views?-PatP |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-03 : 09:01:56
|
| Information_Schema.Tables will give the limited details about the table.... for getting more detail then you need to link to the Columns view.. where as sp_help get direct details about the particular database object.If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|
|
How could get table defination