Data Definition

For a complete syntax description of the SQL statements for data definition, see Data Definition in the SQL reference manual.

Below are just a few examples of key SQL statements for data definition.

Prerequisites

You require the demo data for the SQL Tutorial.

Start the query tool SQL Studio as database administrator MONA with password RED and log on to the demo database instance DEMODB.

Examples

Tables

Constraints

Primary Key

Foreign Key Dependencies Between Tables

View Tables

Indexes

Domains

Database Procedures

Database Functions

Database Triggers

Number Generators for Tables

Number Generator for a Single Table Column