SQL Help Commands Review
Last Updated: May 14, 2021 2:08:13 PM PDT
Give feedback
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 the SQL programming language, you can use QueryLink by clicking the Queries button in FinancialLink, EmployeeLink, Student/ Class Info tools, and DataLink.
| 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. |
For more information, contact the Data Warehouse team.