Adding, Replacing, and Dropping Data on SQL Tables › Drop Table Example

Drop Table Example

The code needed to delete an SQL table definition using CA Culprit is given below:

CA Culprit Syntax

 col. 2
 ▼
 IN 80
 REC FIELDA  1 4
 01OUTPUT  SQLTABLE=INVENTORY  TYPE=DROP
*          DICTIONARY=TSTDICT  SCHEMA=INV
 0151*001  ' '
 017       DROP

Report Output

SQL TABLE UPDATE STATISTICS

REPORT  FUNCTION    SCHEMA    TABLE NAME    TABLE DEFINITION   ROWS STORED
------  ────────    ──────    ──────────    ────────────────   ───────────

  01      DEL     INV         INVENTORY          DELETED