Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DESCRIBE command for SQL Server 1

Status
Not open for further replies.

Chopsaki

Programmer
Nov 21, 2001
85
US
I am sure this has already been asked but I cannot seem to be able to search these forums.
Can anyone tell me what the equiv to desc is in t-sql?

foo
 
I think its

EXEC sp_help tableName

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

fart.gif
 
If you want to call sp_Help quickly, in the Query Analyzer type the table name, between double quotes:

[tt]"Customer"[/tt]

and press Alt + F1 (select it before if there are more statements in the editor).

Have a nice day! ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top