test/sql/DDL/exp.test001.ksh

   1 echo create table t1(f1 bigint, f2 int, f3 smallint, f4 tinyint, f5 char(10), f6 varchar(10), f7 float,f8 double, f9 time, f10 date, f11 timestamp);
   2 Statement Executed
   3 Statement Executed: Rows Affected = 1
   4 Statement Executed: Rows Affected = 1
   5 Statement Executed: Rows Affected = 1
   6 echo select * from t1;
   7 ---------------------------------------------------------
   8         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11
   9 ---------------------------------------------------------
  10         1001    101     11      1       CSQL1   Lakshya1        2010.000000     5012010.000000  10:0:0.0        2010/1/5        2010/1/5 10:0:0.0
  11         1002    102     12      2       CSQL2   Lakshya2        2010.000000     5012010.000000  10:0:0.0        2010/2/5        2010/2/5 10:0:0.0
  12         1003    103     13      3       CSQL3   Lakshya3        2010.000000     5012010.000000  10:0:0.0        2010/3/5        2010/3/5 10:0:0.0
  13
  14 echo truncate table t1;
  15 Statement Executed: Rows Affected = 3
  16 echo select * from t1;
  17 ---------------------------------------------------------
  18         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11
  19 ---------------------------------------------------------
  20
  21 Statement Executed