SQL$HELP72.HLB  —  DECLARE  TABLE  Arguments

1  –  character-set-name 

    A valid character set name. See the Oracle Rdb SQL Reference
    Manual for more information on character sets.

2  –  col-constraint 

    A column constraint. See the CREATE TABLE statement for more
    information about column constraints.

3  –  column-name 

    The name of the column you want to define.

4  –  data-type 

    The data type of the column you want to define. See the Data_
    Types HELP topic for more information on data types.

5  –  date-time-data-types 

    Data types for dates, times, and intervals. See  the Data_Types
    HELP topic for more information on date-time data types.

6  –  declare-col-definition 

    The definition for a column in the table. The column definition
    must correspond to the table definition in the schema.

    See the CREATE TABLE statement for more information about column
    definitions.

    However, you cannot refer to domain names in a DECLARE TABLE
    statement. For tables whose definitions refer to domain names,
    you must substitute the data type and size of the domain for the
    domain name.

7  –  frac 

    Precision specifications for date-time data types. See the Data_
    Types HELP topic for more information.

8  –  interval-qualifier 

    Precision specifications for date-time data types. See the Data_
    Types HELP topic for more information.

9  –  prec 

    Precision specifications for date-time data types. See the Data_
    Types HELP topic for more information.

10  –  references-clause 

    See the CREATE TABLE statement for more information.

11  –  seconds-prec 

    Precision specifications for date-time data types. See the Data_
    Types HELP topic for more information.

12  –  sql-and-dtr-clause 

    Optional SQL and DATATRIEVE formatting clause. See the DATATRIEVE
    HELP topic for more information about formatting clauses.

13  –  table-name 

    The name of the table definition you want to declare.

14  –  view-name 

    The name of the view definition you want to declare.

15  –  table-constraint 

    A constraint definition that applies to the whole table. See
    the CREATE TABLE statement for more information about specifying
    table constraints.
Close Help