Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Introduction to system procedures » Adaptive Server Enterprise system and catalog procedures


Adaptive Server Enterprise catalog procedures

SQL Anywhere implements a subset of the Adaptive Server Enterprise catalog procedures. The implemented catalog procedures are described in the following table.

Catalog procedure name Description
sp_column_privileges Unsupported
sp_columns Returns the data types of the specified columns
sp_fkeys Returns foreign key information about the specified table
sp_pkeys Returns primary key information about the specified table
sp_special_columns Returns the optimal set of columns that uniquely identify a row in the specified table
sp_sproc_columns Returns information about a stored procedure's input and return parameters
sp_statistics Returns information about tables and their indexes
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 for the specified table