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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » Adaptive Server Enterprise system and catalog procedures

Adaptive Server Enterprise system procedures Next Page

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 nameDescription
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