SQL Server Transact Basic to Expert - Get table information

SQL Server Transact Basic to Expert - Get table information

This blog shows how to get the table information using the inbuilt system procedure.

Syntax:
Exec Sp_help Schema.Tablename

Example:
EXEC sp_help dbo.emptable

sp_help is the system procedure in sql which gives the details of the table