SQL script

Top  Previous  Next
CREATE crash tables
oCREATE statement for tables using source/documented field types if possible, otherwise select field types by reviewing content. Preference to integer types for categorical fields when possible. Scripts should include primary key constraint and appropriate indexes based on Query - Study content. Typical tables will be:
Streets (can usually be copied from another configuration)
Nodes (only if using a node field - rare)


DELETE from crash tables
oDELETE statement for crash data. Leave table structure intact.


DROP crash tables
oDROP statement for each crash data table


CREATE lookup tables
oCREATE statement for lookup table.
oFields must match columns in Query - Lookups.
oCan usually be copied from another configuration.


INSERT lookups
oMultiple INSERT statements to populate the lookup table(s).


DROP" lookup tables
oDROP statement for each lookup table