Sybase Adaptive Server Anywhere - Page 1007

Chapter 14 System Procedures and Functions
989
System procedure Description
sp_dboption [dbname,
optname, {true | false}]
Displays or changes a database option
sp_dropgroup group-name
Drops a group from a database
sp_droplogin userid
Drops a user from a database
sp_dropmessage message-
number [, language]
Drops a user-defined message
sp_droptype typename
Drops a user-defined data type
sp_dropuser userid
Drops a user from a database
sp_getmessage message-
num, @msg-var output [,
language]
Retrieves a stored message string from
SYSUSERMESSAGES, for PRINT and
RAISERROR statements.
sp_helptext object-name
Displays the text of a system procedure, trigger,
or view
sp_password caller_passwd,
new_passwd [, userid]
Adds or changes a password for a user ID
Adaptive Server Enterprise catalog procedures
Adaptive Server Anywhere implements a subset of the Adaptive Server
Enterprise catalog procedures. The implemented catalog procedures are
described in the following table.
Catalog procedure Description
sp_column_privileges
Unsupported
sp_columns table-name [,
table-owner ] [, table-
qualifier] [, column-name]
Returns the data types of the specified columns
sp_databases
Unsupported
sp_datatype_info
Unsupported
sp_fkeys pktable_name [,
pktable-owner][, pktable-
qualifier] [, fktable-name] [,
fktable_owner] [, fktable-
qualifier]
Returns foreign key information about the
specified table
sp_pkeys table-name [,
table_owner] [,
table_qualifier]
Returns primary key information about the
specified table
sp_server_info
Unsupported