Sybase IQ implements all the Adaptive Server Enterprise catalog procedures with the exception of the sp_column_privileges procedure. The implemented catalog procedures are described in the following table.
The following list describes the supported Adaptive Server Enterprise catalog procedures.
Catalog procedure |
Description |
|---|---|
sp_column_privileges |
Unsupported |
sp_columns |
Returns the data types of the specified column |
sp_fkeys |
Returns foreign key information about the specified table |
sp_pkeys |
Returns primary key information for a single table |
sp_special_columns |
Returns the optimal set of columns that uniquely identify a row in a table |
sp_sproc_columns |
Returns information about a stored procedure's input and return parameters |
sp_stored_procedures |
Returns information about one or more stored procedures |
sp_tables |
Returns a list of objects that can appear in a FROM clause |
