SQL data definition statements are used in applications the sole purpose of which is to create or modify databases or tables. Typically the expectation is that these applications will be used only once by any given user, then discarded, or saved for later modification by a database designer who can read the program code as a record of a database’s structure. If data definition changes must be made, editing a copy of existing code is easier than starting over.
CREATE statement is used to make new databases, domains, tables, views, or indexes. A
COMMIT statement must follow every
CREATE so that subsequent
CREATE statements can use previously defined metadata upon which they may rely. For example, domain definitions must be committed before the domain can be referenced in subsequent table definitions.
- Metadata Names
- Creating a Database
- Creating a Domain
- Creating a Table
- Creating a View
- Creating an Index
- Creating Generators