コンテンツエリア開始

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

For a complete syntax description of the SQL statements for data definition, see Structure linkData 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 Structure linkSQL 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

 

コンテンツエリア終了