SQL-DELETE-TABLE is a TCL command that deletes an entry in the sql.tables, file without deleting the corresponding D3 file.
SQL-DELETE-TABLE tablename|filepath {(it)}
The syntax has the parts:
| Part | Description | |
|---|---|---|
| tablename | Name of the table to delete. | |
| filepath | File path of the table. | |
| options | i | Suppresses deleted table names. |
| t | Indicates that the tablename parameter is an internal table name, not a D3 file name. If the t option is not used, tablename|filepath indicates a D3 path which may contain full account and file name references. | |
To delete all tables defined for the D3 file customers within the current account:
SQL-DELETE-TABLE cust (t
To delete the table called cust regardless of the actual D3 account and file name:
SQL-DELETE-TABLE cust (t