Ingres 11.0 | DECLARE TABLE Example

OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Statements > DECLARE TABLE > DECLARE TABLE Example

Was this helpful?

DECLARE TABLE Example

The following is a DECLARE TABLE statement example for a database table:

EXEC SQL DECLARE employee TABLE
       (eno    INTEGER2 NOT NULL,
       ename   CHAR(20) NOT NULL,
       age     INTEGER1,
       job     INTEGER2,
       sal     FLOAT4,
       dept    INTEGER2 NOT NULL);

Last modified date: 01/30/2023