Building the Right Environment to Support AI, Machine Learning and Deep Learning

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


Visit the DevX Tip Bank


Source link


Please enter your comment!
Please enter your name here