Using Data Definition Language Statements to Manage Database Objects

Previous

Next

Data definition language (DDL) statements include CREATE, ALTER, and DROP to manage database objects. When managing database objects, the Object Browser page provides a Web-based user interface that can be used instead of SQL DDL statements. See "Managing Database Objects With Object Browser".

In this guide, some basic SQL DDL statements are used in the code examples and a brief description of some DDL statements are discussed in this section.

This section contains the following topics:

• Creating a Table With SQL

• Adding, Altering, and Dropping a Table Column With SQL

• Creating and Altering a Constraint With SQL

• Renaming a Table With SQL

• Dropping a Table With SQL

• Creating, Altering, and Dropping an Index With SQL

• Creating and Dropping a View With SQL

• Creating and Dropping a Sequence With SQL

• Creating and Dropping a Synonym With SQL