SQL Anywhere implements a subset of the Adaptive Server Enterprise catalog procedures. While these procedures perform the same functions as they do in Adaptive Server Enterprise, they are not identical. If you have preexisting scripts that use these procedures, you may want to review the procedure code. To see the text of a stored procedure, execute the following command.
sp_helptext 'dbo.procedure_name' |
The implemented catalog procedures are described in the following table.
| Catalog procedure name / parameters | Description |
|---|---|
| sp_column_privileges | Unsupported |
| sp_columns [ @table_name [, @table_owner [, @table_qualifier [, @column_name ] ] ] ] | Returns the data types of the specified columns |
| 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_special_columns @table_name [, @table_owner [, @table_qualifier [, @col_type ] ] ] | Returns the optimal set of columns that uniquely identify a row in the specified table |
| sp_sproc_columns @sp_name [, @sp_owner [, @sp_qualifier [, @column_name ] ] ] | Returns information about the input and return parameters of a stored procedure |
| sp_statistics [ @table_name [, @table_owner [, @table_qualifier [, @index_name [, @is_unique ] ] ] ] | Returns information about tables and their indexes |
| sp_stored_procedures [ @sp_name [, @sp_owner [, @sp_qualifier ] ] ] | Returns information about one or more stored procedures |
| sp_tables [ @table_name [, @table_owner [, @table_qualifier [, @table_type ] ] ] | Returns a list of objects that can appear in a FROM clause |
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |