previous | index | next

Creating a Table

Basic syntax:
   CREATE TABLE name (col1 type1, col2 type2, ...);

Note: Keywords are shown in upper-case for clarity, although case is ignored for keywords.

Example:

   CREATE TABLE pet (name VARCHAR(20), 
                     owner VARCHAR(20),
                     species VARCHAR(20),
                     sex CHAR(1),
                     birth DATE,
                     death DATE);

previous | index | next