An optional identifier of the schema for the table, view, or index. If specified for the index-name, it must be the same as the authorization ID of the table you have specified with the tab-name in the FROM tab-name clause. Use a period (.) to concatenate the authorization ID to the table or view name, for example, authid.tab-name.
Indicates that the object you are dropping is a table.
Specify the name of the table you want to drop. The tab-name must identify a table described in the Datadictionary, other than a Datadictionary table.
The DROP TABLE statement removes the table from the schema, obsoletes the table from the Datadictionary, and removes the table from the CA Datacom/DB Directory (CXX).
Important! The table data is deleted and the space is reclaimed when you drop a table.
All views and synonyms based on the table are dropped. All application plans and statements that reference the table are invalidated. If the table definition exists in TEST and/or HISTory status in Datadictionary, those status/versions are deleted at the same time as the PRODuction status.
All columns (columns appear as FIELD occurrences in Datadictionary ), keys, elements, and support data related to the table are also obsoleted. The support data includes aliases, descriptors, relationship definitions, and text (SQL comments).
Indicates that the object you are dropping is a synonym.
Specify the name of the synonym you want to drop. Dropping a synonym does not affect the table, view or synonym referenced by the dropped synonym.
Indicates that the object you are dropping is a view.
Specify the name of the view you want to drop. The view name must identify a view described in the Datadictionary. The definition of the view is removed from the Datadictionary. The definition of any view that is directly or indirectly dependent on that view is also removed. When the definition of a view is removed from the Datadictionary, all privileges on that view are also dropped.
Not used in CA Dataquery.
|
Copyright © 2014 CA.
All rights reserved.
|
|