Describe table structure in MS SQL Server


I liked the describe MyTable in MySQL and missed it on SQL Server when I started to work with it. Turns out, there is a way to do the same there as well:

exec sp_columns MyTable

This is not exactly the same as describe MyTable but it serves similar purpose.

One thought on “Describe table structure in MS SQL Server

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.