Creating Metadata
Go Up to Working with Data Definition Statements
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.
The SQL 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.
Topics
- Metadata Names
- Creating a Database
- Creating a Domain
- Creating a Table
- Creating a View
- Creating an Index
- Creating Generators