summaryrefslogtreecommitdiff
path: root/sql/testmdx.sql
blob: 859334b0fb287298fd9f71e0cd41769401db4d80 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
# HELP;

USE /opt/1Tdata/xbase/xbase.30/data;

DROP TABLE IF EXISTS TestSqlM.DBF;

CREATE TABLE TestSqlM.DBF( CHRFLD CHAR(6), DTFLD DATE, INTFLD INTEGER, SMINTFLD SMALLINT, NUMFLD NUMERIC(9,4), DECFLD DECIMAL(9,4), FLTFLD FLOAT(9,4)  LGFLD LOGICAL ); 

# CREATE INDEX TestSqlM ON TestSqlM.DBF( CHRFLD );