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

LEAVE A REPLY

Please enter your comment!
Please enter your name here