Filter
Top Products
Deleting index storage structures
To delete index storage structures, use the DROP DSI and DROP DSO statements.
Example:
Delete the index DSI and index DSO belonging the STOCKMN_DB.
When the DSI specified in the DROP DSI statement is deleted, all data stored in the database space allocated to that
DSI becomes invalid.
When the index storage structure is defined by an index definition, use the following method to delete it.
Example:
Delete the index belonging to STOCKMN_DB.
The index specified in the DROP INDEX statement is deleted. At this time, the index DSI and index DSO are deleted.
Deleting table storage structures
To delete table storage structures, use the DROP DSI and DROP DSO statements.
Example:
Delete the table DSIs and table DSO belonging to STOCKMN_DB.
The table DSIs specified in the DROP DSI statements and the table DSO specified in the DROP DSO statement are
deleted.
135