Isql tutorial
- isql show tables
- psql show tables
- psql show tables in schema
- psql show tablespaces
Isql commands...
Part II. Tutorials
Chapter 5.
Firebird isql show tables
Using ISQL
Displaying data in ISQL
To list all the columns and rows of the employee table:
- Type the following:
| emp_id | manager_id | emp_lname | emp_fname | ... |
|---|---|---|---|---|
| 102 | 501 | Fran | Whitney | ... |
| 105 | 501 | Matthew | Cobb | ... |
| 129 | 902 | Philip | Chin | ... |
| 148 | 1293 | Julie | Jordan | ... |
| 160 | 501 | Robert | Breault | ... |
| ... |
Notes
- SQL statements are case insensitive.
SELECT is the same as select is the same as Select. In the examples, SQL keywords are shown in upper case, but you do not have to type them in upper case.
- SQL statements can be typed on more than one line. You can type the statements all on one line, or break them over several lines as you wish.
Some SQL statements, such as the SELECT statement, consist of several parts, called clauses. In many examples, each clause is placed on a separate line, but you do not have to type them this way.