Many database management systems cannot build a database, table, or index if one already exists. The DROP statement that appears in the generated DDL is a logical data definition statement that removes the description of a database or its components from the system. For certain DBMSs, a DROP statement is necessary before a new database or its components can be rebuilt.
You can also specify generation of the DROP statement for one or more database components from the DDL Generation window. The DROP column on the DDL Generation window overrides the DROP selection on the Generation Defaults window. In addition, when a component is dropped, all the data associated with that component is dropped as well.
Important! The DROP statement deletes a database and all of its data. Back up the data, if you need it before you DROP a database.
|
Copyright © 2013 CA.
All rights reserved.
|
|