Tuesday, June 26, 2007

How to view structure of a table using Ms Sql Server

How to view structure of a table using Ms Sql Server
=========================================


You must be aware of describe table / desc table statement in oracle. By using this statement you can view the structure of a oracle table.

Same way in Ms Sql Server you can do the same by using
sp_columns store procedure.

Eg: sp_columns myTable

No comments: