Index Create Script Template

-- ------------------------------------------------------------------------- -- -- -- -- Title: [table_name]_i.sql -- -- Author: Steve Roach -- -- Date: DD-MON-YYYY -- -- Version: 01.00 -- -- -- -- Description: Create indexes for table [TABLE_NAME]. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- DD-MON-YY 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- DROP INDEX [table_name]_pk / CREATE [UNIQUE] INDEX [table_name]_pk ON [table_name] ( [column_1] ,[column_2] ,.. ) /