#escape(sField.ColumnName)# #UCase(type)#(#sField.Length#)(#Val(sField.precision)#,#Val(sField.scale)#) DEFAULT #sField.Default# NOT NULL
CREATE TABLE #escape(arguments.tablename)# (
#sqlCreateColumn(arrFields[ii])# ,,
CONSTRAINT "#arguments.tablename#_PK" PRIMARY KEY (#pkfieldsSQL#) ENABLE
);
CREATE SEQUENCE #escape("#arguments.tablename#_SEQ")#;
CREATE OR REPLACE TRIGGER #escape("BI_#arguments.tablename#")# #lf# before insert on #escape(arguments.tablename)##lf# for each row #lf#begin #lf# select #escape("#arguments.tablename#_SEQ")#.nextval into :NEW.#escape(arrFields[seqField].ColumnName)# from dual|DataMgr_SemiColon|#lf#end|DataMgr_SemiColon|
var qStructure = 0;
var qPrimaryKeys = 0;
var qIndices = 0;
var TableData = ArrayNew(1);
var tmpStruct = StructNew();
var PrimaryKeys = "";
var sqlarray = ArrayNew(1);
var qSequences = 0;
var Sequences = "";
/* @@Note: The table name in the config file may be specified as upper, lower or mixed case.
Almost everyone in the known universe create table and column names in upper case.
So first check for the table as provided. If not found, then check for the
uppercased table.
*/
var qTable = runSQL("SELECT object_name table_name FROM user_objects where object_type = 'TABLE' and object_name = '#arguments.tablename#'");
0 THEN 1 ELSE 0 END,0)")>