Filter
Top Products
CHAPTER 1 Overview of Adaptive Server IQ System Administration
11
Adaptive Server Enterprise catalog procedures
Adaptive Server IQ implements all the Adaptive Server Enterprise catalog
procedures with the exception of the
sp_column_privileges procedure. The
implemented catalog procedures are described in the following table.
The following list describes the supported Adaptive Server Enterprise catalog
procedures.
Catalog stored procedures
In addition to the Adaptive Server Enterprise Catalog stored procedures, there
are other system and catalog stored procedures. The following table lists the
ones you are most likely to use. For a complete list, see Chapter 14, “System
Procedures” in Adaptive Server IQ Reference Manual.
sp_helptext Displays the text of a system procedure or
view
sp_password Adds or changes a password for a user ID
System procedure Description
Catalog procedure Description
sp_column_privileges Unsupported
sp_columns Returns the data types of the specified column
sp_fkeys Returns foreign key information about the
specified table
sp_pkeys Returns primary key information for a single
table
sp_special_columns Returns the optimal set of columns that
uniquely identify a row in a table
sp_sproc_columns Returns information about a stored procedure’s
input and return parameters
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
Procedure name Purpose
sp_remote_columns List remote tables columns and their
data types
sp_remote_tables List tables on a remote server