Neoview SQL Reference Manual (R2.4 SP2)

TABLE Statement
• “Considerations for TABLE”
• “Examples of TABLE”
The TABLE statement is equivalent to the query specification SELECT * FROM table.
TABLE table
table
names the user table or view.
Considerations for TABLE
Relationship to SELECT Statement
The result of the TABLE statement is one form of a simple-table, which refers to the definition
of a table reference within a SELECT statement. See the “SELECT Statement” (page 163).
Examples of TABLE
• This TABLE statement returns the same result as SELECT * FROM job:
TABLE job;
Job/Code Job Description
-------- --------------------
100 MANAGER
200 PRODUCTION SUPV
250 ASSEMBLER
300 SALESREP
400 SYSTEM ANALYST
420 ENGINEER
450 PROGRAMMER
500 ACCOUNTANT
600 ADMINISTRATOR
900 SECRETARY
--- 10 row(s) selected.
196 SQL Statements