Cry How to...

List table information

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: Brian Cryer
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.