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 |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |