Listing all the columns and rows of the employee table

To list the data stored within database tables, type a SELECT command in the Interactive SQL Classic (dbisqlc) command window, then press F9 (if supported), or Command | Execute from the menu to carry out the command. The example output that follows shows the first several columns and rows of the results of the query which appear in the Interactive SQL Classic data window.

Enter:

SELECT *
FROM Employees

• In the examples, SQL keywords are shown in uppercase; however, SQL statements are case-insensitive.

• In many examples, each clause of a SQL statement is placed on a separate line for readability. You can enter SQL statements either all on one line, or you can break them over several lines.