Fujitsu J2X0-2273-01EN Server User Manual


 
Tables:
STOCK, ORDER, and STOCK_TEMPORARY TABLE
Table DSO:
ORDER_DSO
Table DSIs:
STOCK_DSI and WEST_ORDER_DSI
Index:
STOCK_TEMPORARY_IX
Index DSO:
PRODUCT_IXDSO
Index DSI:
PRODUCT_IXDSI
Database spaces:
DBSPACE_1, DBSPACE_2
Procedure routine:
PROC002
Function routine:
USER001
Trigger:
ORDER_TRIGGER
Scope:
TOKYO_SCOPE
Deleting temporary tables
To delete a temporary table, use the DROP TABLE statement.
Example:
Deletes temporary table STOCK_TEMPORARY.
Deleting temporary table indexes
To delete the index of a temporary table, use the DROP INDEX statement.
Example:
Deletes temporary table index STOCK_TEMPORARY_IX.
Deleting scopes
To delete a scope, use the DROP SCOPE statement.
Example:
Delete scope TOKYO_SCOPE.
134