Getting Information About the Structure of Tables in SQL

Sp_help?provides a lot of information about the structure of the tables inside your database. You can highlight a table name in the SQL Query editor and then press the Alt + F1 key combination or you could type a command such as the following:

sp_help 'TableName'

This will produce a few results, including the following:

Table name with its creation dateTable columns with their respective datatypesPrimary Key informationIndex informationConstraint information
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: