Country Dimension - o_countries_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: o_countries_c.sql -- -- Author: Steve Roach -- -- Date: 25-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table ODS.O_COUNTRIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 26-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE o_countries DROP CONSTRAINT o_countries_pk / ALTER TABLE o_countries ADD CONSTRAINT o_countries_pk PRIMARY KEY ( name ,start_date ) USING INDEX o_countries_pk /