ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 407
SQL Statements A - D
DROP TABLE
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