SQL script

•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:

▪Crash

▪Vehicle

▪Party

▪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