Sp_help provides a lot of about the of the inside your database. You can highlight a table name in the 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 date
Table columns with their respective datatypes
Primary Key information
Index information
Constraint information

Source link


Please enter your comment!
Please enter your name here