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.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.