User's Guide

Part II. Tutorials

Chapter 14. System Tables

Another important system table is called SYSCOLUMNS describing all the columns in all the tables in the database. To see the contents of this table, type the command:

     SELECT *
     FROM sys.syscolumns
     WHERE tname = 'employee'

This command lists all the columns in the employee table. If you look at the columns to the right, you can see from the Coltype column that some columns in the employee table contain character information; others contain integer and date information.