SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-228

TABLE Statement

Considerations for TABLE

Examples of TABLE

The TABLE statement is equivalent to the query specification SELECT * FROM

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 is part of

the definition of a table reference within a SELECT statement. See SELECT Statement

on page 2-178.

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.

TABLE table