:::: MENU ::::

Get detailed information about a table with sp_helpDB

dbDigger, Monitoring and Analysis, System Stored Procedures

Get detailed information about a table with sp_helpDB

To get relevant information about a specific table, following stored procedure may be used

 
USE DBNameHere  
 GO  
 EXEC sp_help tableNameHere  
 GO  

For example in case of adventure works database, if we require information about vVendor table, then our script will be in following form

 
USE AdventureWorks  
 GO  
 EXEC sp_help [Purchasing.vVendor]  
 GO  

Valuable system stored procedure (sp_helpDB) may be used in all versions of SQL Server.

Consult us to explore the Databases. Contact us