8. SQL Statements : HELP : HELP Examples
 
Share this page                  
HELP Examples
1. Display a list of all tables, views, and indexes to which the user has access.
HELP;
2. Display help about all tables starting with ā€œeā€ to which the user has access.
HELP *.e*;
3. Display help about the employee and dept tables.
HELP employee, dept;
4. Display the definition of the view, highpay.
HELP view highpay;
5. Display all permits issued on the job and employee tables.
HELP PERMIT ON TABLE job, employee;
6. Display all integrity constraints issued on the dept and employee tables.
HELP INTEGRITY dept, employee;
7. Display information on the SELECT statement.
HELP SQL select;