First Guide to SQL Anywhere Studio
   PART 3. Basic SQL
     CHAPTER 18. System Tables       

The SYSCOLUMNS table

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.