These are the syntax and very brief descriptions for Adaptive Server catalog stored procedures. See Reference Manual: Procedures for complete information.
Returns permissions information for one or more columns in a table or view.
sp_column_privileges table_name [, table_owner [, table_qualifier [, column_name]]]
Returns information about the type of data that can be stored in one or more columns.
sp_columns table_name [, table_owner ] [, table_qualifier] [, column_name]
Returns a list of databases in Adaptive Server.
sp_databases
Returns information about a particular ODBC datatype or about all ODBC datatypes.
sp_datatype_info [data_type]
Returns information about foreign key constraints created with the create table or alter table command in the current database.
sp_fkeys pktable_name [, pktable_owner] [, pktable_qualifier] [, fktable_name] [, fktable_owner] [, fktable_qualifier]
Returns information about primary key constraints created with the create table or alter table command for a single table.
sp_pkeys table_name [, table_owner] [, table_qualifier]
Returns a list of Adaptive Server attribute names and current values.
sp_server_info [attribute_id]
Returns the optimal set of columns that uniquely identify a row in a table or view; can also return a list of timestamp columns, whose values are automatically generated when any value in the row is updated by a transaction.
sp_special_columns table_name [, table_owner] [, table_qualifier] [, col_type]
Returns information about a stored procedure’s input and return parameters.
sp_sproc_columns procedure_name [, procedure_owner] [, procedure_qualifier] [, column_name]
Returns a list of indexes on a single table.
sp_statistics table_name [, table_owner] [, table_qualifier] [, index_name] [, is_unique]
Returns information about one or more stored procedures.
sp_stored_procedures [sp_name [, sp_owner [, sp_qualifier]]]
Returns privilege information for all columns in a table or view.
sp_table_privileges table_name [, table_owner[, table_qualifier]]
Returns a list of objects that can appear in a from clause.
sp_tables [table_name] [, table_owner][, table_qualifier][, table_type]
