Data Definition 

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

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

Prerequisites

You need the HOTEL Demo Schema for the SQL Tutorial.

To log on to the database instance DEMODB, start the SQL Studio query tool as the database administrator MONA with the password RED.

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