Cry How to...

List table information

To get information about a table in an SQL Server database, use:

sp_help <table-name>

where: <table-name> is the name of the table for which details are required.

This lists the table name, columns, indexes and other information about the table. Further details can be found by consulting the SQL Server documentation.

These notes have been tested against SQL Server 7 and SQL Server 2000.