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 the input and return parameters of a stored procedure |
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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |