SHOW TABLES
Go Up to isql Command Reference
Lists all tables or views, or displays information about a specified table or view.
SHOW {TABLES | TABLE name};
| Argument | Description |
|---|---|
|
<name> |
Name of an existing table or view in the current database |
Description: SHOW TABLES displays an alphabetical list of tables and views in the current database. To determine which listed objects are views rather than tables, use SHOW VIEWS.
SHOW TABLE name displays information about the named object. If the object is a table, command output lists column names and definitions, PRIMARY KEY, FOREIGN KEY, and CHECK constraints, and triggers. If the object is a view, command output lists column names and definitions, as well as the SELECT statement that the view is based on.
Examples: To list all tables or views defined for the current database, enter:
SHOW TABLES;
COUNTRY CUSTOMER
DEPARTMENT EMPLOYEE
EMPLOYEE_PROJECT JOB
PHONE_LIST PROJECT
PROJ_DEPT_BUDGET SALARY_HISTORY
SALES
To show the definition for the COUNTRY table, enter:
SHOW TABLE COUNTRY;
COUNTRY (COUNTRYNAME) CHAR(15) NOT NULL
CURRENCY CHAR(10) NOT NULL
PRIMARY KEY (COUNTRY)