Listing the tables in a database

Sybase IQ provides a number of built-in functions called system stored procedures. Use these procedures to display information about your database.

For example, use the sp_iqtable stored procedure to list the tables in the sample database. To run a stored procedure, type its name (and any parameters) in the command window.

See Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures.