SQL CREATE TABLE command - ALIAS

["Dave Odom" <Dave.Odom@xxxxxxxxxxxx>]

Joe,

The following SQL is an example of what can be done on DB2/400 and I
know is compatible with other DB2s.  Of course, you can pretty much use
or not use as much or as little in the way of internal documentation as
you wish.   Don't know what databases your working with but, of course,
Oracle does things differently (what a shock).  

What I've created below is just a test that shows how creative you can
be with names and labels in the DB2 CREATE TABLE statement:
 
CREATE TABLE DODOM1.TEST ( 
        TEST_COL_1 FOR COLUMN TEST1      CHAR(10) CCSID 37 DEFAULT NULL
, 
        TEST_COL_2 FOR COLUMN TEST2      CHAR(10) CCSID 37 DEFAULT NULL
) ; 
  
LABEL ON TABLE DODOM1.TEST 
        IS 'Test table' ; 
  
LABEL ON COLUMN DODOM1.TEST 
( TEST_COL_1 IS 'Test Column 1' , 
        TEST_COL_2 IS 'Test Column 2' ) ; 
  
LABEL ON COLUMN DODOM1.TEST 
( TEST_COL_1 TEXT IS 'Test Column 1' , 
        TEST_COL_2 TEXT IS 'Test Col 2' ) ; 
  

HTH,

Dave Odom
Arizona