DROP TABLE

The DROP TABLE statement deletes the specified table, including any hash structure or constraints associated with it, all indexes, views, and rules defined on the table, and all authorizations granted on the table.

Scope

ISQL or Application Programs

SQL Syntax

DROP TABLE [Owner.] TableName

Parameters

[Owner.]TableName: identifies the table to be dropped.

Description

The DROP TABLE statement may invalidate stored sections. Refer to the ALLBASE/SQL Database Administration Guide for additional information on section validation.
You cannot drop a table which has a primary or unique constraint referenced by a foreign key in another table. (You can, however, if the only foreign keys are within the same table.)
Any authorities used to authorize a foreign key on the table are released when the table is dropped.

Authorization

You can issue this statement if you have OWNER authority for the table or if you have DBA authority.

Example

This table is private by default.

   CREATE TABLE VendorPerf

               (OrderNumber  INTEGER  NOT NULL,

               ActualDelivDay  SMALLINT,

               ActualDelivMonth  SMALLINT,

               ActualDelivYear  SMALLINT,

               ActualDelivQty  SMALLINT

               Remarks  VARCHAR(60) )

            IN Miscellaneous



   CREATE UNIQUE INDEX VendorPerfIndex

                    ON VendorPerf

                       (OrderNumber)



   CREATE VIEW VendorPerfView

               (OrderNumber,

               ActualDelivQty,

               Remarks)

     AS SELECT OrderNumber,

               ActualDelivQty,

               Remarks

          FROM VendorPerf

Only the table creator and members of authorization group Warehse can update table VendorPerf.

   GRANT UPDATE ON VendorPerf TO Warehse

The table, the index, and the view are all deleted; and the grant is revoked.

   DROP TABLE VendorPerf