prikey: BEFORE_LOAD ORDER_BY_PKEY
seckey: AFTER_LOAD
cretab: CREATE TABLE &tab_name&
( /{ &fld_name& &fld_desc& /-, /} )
# to deactivate row compression on SQL 2008 and higher
# add &norowcompression& after the closing bracket:
# cretab: CREATE TABLE &tab_name&
# ( /{ &fld_name& &fld_desc& /-, /} )
&norowcompression&
drptab: DROP TABLE &tab_name&
crepky: ALTER TABLE &tab_name&
ADD CONSTRAINT &pri_key&
PRIMARY KEY &clustered& ( /{ &key_fld& /-, /} )
drppky: ALTER TABLE &tab_name&
DROP CONSTRAINT &pri_key&
creind: CREATE &unique& INDEX &ind_name&
ON &tab_name&
( /{ &fld_name& /-, /} )
drpind: DROP INDEX &tab_name&.&ind_name&
crevie: CREATE VIEW &view_name&
( /{ &fld_name& /-, /} )
AS &query&
drpvie: DROP VIEW &view_name&
trcdat: TRUNCATE TABLE &tab_name&
deldat: DELETE FROM &tab_name& &where&
negtab: LICHECK MLICHECK
negdat: LICHECK MLICHECK
negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0
negvie:
