how to see the Table structure in the Query Analyzer MS SQL Server

I am trying to check the table structure of given table in Query Analyzer.

I am trying to see the anything equivalent Of Describe in Mysql in SQL serv开发者_如何学Goer

I found sp_help, but that gives me more than what I expect.

Try

SELECT * 
FROM   information_schema.columns
WHERE  table_name = 'YourTable' 

sp_columns also works but that's 2005 and up and you reference "Query Analyzer" which is for 2000