Progress
SQL-92
Guide and Reference


Create a Table

This section contains an SQL-92 script that creates the team table in an existing database.

Team_cre.sql
------------------------------------------------------------------------- 
-- File Name: Team_cre.sql
--
-- Purpose:  Creates the team table in the y2ksports database, a copy of
--           the sports2000 database.
--
-- Requirements:
--           (1) Create the database by copying SPORTS2000.
--               Example: prodb y2ksports sports2000
--           (2) Start the database.
--               Example: proserve y2ksports -S 800
--           (3) Submit this script to SQL Explorer as an input file
--              (character mode) or as a run file (GUI mode). 
--           
-- Revision History:
-- 
-- Date                Author                     Change 
-- -----              --------                   --------
--
-- 11/99               DB-DOC                     Created, V9.1A
-----------------------------------------------------------------------

create table team (
    FirstName    varchar(30) not null,
    LastName     varchar(50) not null,
    empnum       integer CONSTRAINT employee not null PRIMARY KEY,
    State        varchar(50) not null,
    Sport        char(20)
    ) ;
commit work ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095