Entering content frame

Background documentation Data Definition Locate the document in its SAP Library structure

A full description of the syntax used in the SQL statements regarding data definitions is provided under Data Definition in the Reference Manual.

The following section uses examples to explain a few of the key SQL statements for data definition.

Prerequisites

You need the HOTELDB_SIMPLE version of the model database HOTELDB.

Start the SQL Studio query tool as the database administrator MONA with the password RED.

Examples

·        Tables

·        Constraints

·        Primary Key

·        Foreign Key Relationships Between Tables

·        View Tables

·        Indexes

·        Domain Definitions

·        Database Procedures

·        Database Functions

·        Database Triggers

 

Leaving content frame