SQL Help Commands Review
Last updated
August 21, 2009 7:05:00 AM PDT
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. |
|
