 |
|
Summary: These SQL help commands or stored procedures can provide column, table, and database information directly from the Sybase environment. Use this guide to review how they work. |
|
|
Note: If you don't know SQL programming language, you can use QueryLink, by clicking the Queries button in FinancialLink, EmployeeLink, DataLink, or the Student queries link at Blink Student/ Class Info.
Help command
|
Usage |
| sp_helpdb |
Returns a list of all databases within a selected Sybase server (e.g., DARWIN). When you use the SQL Executer
to submit this command, leave the DB name field blank. |
sp_help
|
Returns a list of all the tables within a specific database (within a selected server). When you use the SQL Executer to submit this
command, you must use a DB name. |
sp_help [table name]
|
Returns a list of all the columns within a specific table within a specific database. When you use the SQL Executer to submit this
command, you must select a DB name and a table name as part of the SQL command. Returned results will show
column and table index information along with some global table ownership and segment ("where stored") information. |
|
If you have questions, contact the Data Warehouse team.
|
|
|
At Your Service Online
