Commands and Syntax › DELETE TABLE—IDMS access mode

DELETE TABLE—IDMS access mode

DELETE TABLE allows you to delete SQL tables provided you hold the appropriate security.

Access mode: The syntax below is invalid when the access switch is set to OLQ.

Syntax:

►►──┬─ DELete TABle ─┬─┬─────┬─┬───────────┬─ sql-table-name ─────────────────►
    └─ DROp TABle ───┘ └─ = ─┘ └─ schema. ─┘

 ►─┬──────────────────────────────────────┬───────────────────────────────────►◄
   └─ DICtname ─┬─────┬─ dictionary-name ─┘
                └─ = ─┘

Parameters:

sql-table-name

Specifies the SQL table to be deleted

schema

The name of the schema associated with the SQL table.

DICTNAME= dictionary-name

Specifies the dictionary containing the catalog entry for the named SQL table.

Example:

In this example, the table definition and associated occurrences for the EMP-HOSPITAL table are deleted:

drop table=emp-hospital

 OLQ 090016 00  Table "EMP-HOSPITAL" successfully DELETED.