Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
DROP TABLE Statement (SQL) (m691508+droptable.htm)
Deletes an SQL table.
DROP TABLE base-table-name
base-table-name =
{owner-name.}base-table-identifier
owner-name
The SQL user-id of the creator of the table.
base-table-identifier
The name of the required table.
Only the SQL owner of the table can perform this statement. The owner of the table must have SQL Catalog Maintenance privilege set in the Reality security profile.
Only the catalog entries for the table will be deleted if the table was not created with the SQL CREATE TABLE statement.
The underlying Reality file and indexes will be deleted if the table was created with the SQL CREATE TABLE statement.
DROP TABLE EMP