Physical Database DDL Statements › SEGMENT Statements › Entity Currency › Examples

Examples

Defining a Segment

The following CREATE SEGMENT statement defines the SALESSEG segment:

create segment salesseg
   for sql
   for schema saleschm
   stamp by area;

Dropping a Segment

The following DROP SEGMENT statement deletes the definition of the segment SALESSEG from the dictionary:

drop segment salesseg;