Adaptive Server Enterprise Catalog Procedures

Sybase IQ implements most of the Adaptive Server Enterprise catalog procedures with the exception of the sp_column_privileges procedure.

Sybase IQ also has similar customized stored procedures for some of these Adaptive Server Enterprise catalog procedures.

ASE catalog procedures implemented in Sybase IQ

ASE catalog procedure

Description

IQ procedure

sp_columns table-name [, table-owner ] [, table-qualifier] [, column-name ]

Returns the data types of the specified column

sp_fkeys pktable_name [, pktable-owner ][, pktable-qualifier ] [, fktable-name ] [, fktable_owner ] [, fktable-qualifier ]

Returns foreign-key information about the specified table

sp_pkeys table-name [, table_owner ] [, table_qualifier ]

Returns primary-key information for a single table

sp_iqpkeys

sp_special_columns table_name [, table-owner ] [, table-qualifier ] [, col-type ]

Returns the optimal set of columns that uniquely identify a row in a table

sp_sproc_columns proc-name [, proc_owner ] [, proc-qualifier] [, column-name ]

Returns information about the input and return parameters of a stored procedure

sp_iqprocparm

sp_stored_procedures [ sp-name ] [, sp-owner ] [, sp-qualifier ]

Returns information about one or more stored procedures

sp_iqprocedure

sp_tables table-name [, table-owner ] [, table-qualifier ] [, table-type ]

Returns a list of objects that can appear in a FROM clause

The following Adaptive Server Enterprise catalog procedures are not supported:
  • sp_column_privileges

  • sp_databases

  • sp_datatype_info

  • sp_server_info