DECLARE @sql [nvarchar](MAX)
SELECT @sql = N'ALTER TABLE [BLC_CUSTOM_FIELD] DROP CONSTRAINT ' + QUOTENAME([kc].[name]) FROM [sys].[key_constraints] AS [kc] WHERE [kc].[parent_object_id] = OBJECT_ID(N'[BLC_CUSTOM_FIELD]') AND [kc].[type] = 'PK'
EXEC sp_executesql @sql
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ALTER COLUMN [FIELD_ID] [numeric](19, 0) NOT NULL
GO

--ALTER TABLE [BLC_CUSTOM_FIELD] ADD CONSTRAINT [PK__BLC_CUST__E86DCC3FC78BDFA7] PRIMARY KEY ([FIELD_ID])
--GO

CREATE UNIQUE CLUSTERED INDEX [PK__BLC_CUST__E86DCC3FC78BDFA7] ON [BLC_CUSTOM_FIELD]([FIELD_ID])
GO

DROP INDEX idx_BLCASEFAEXXR_SNDBX_ID ON [BLC_CAT_SEARCH_FACET_EXCL_XREF]
GO

DROP INDEX idx_BLCASEFAEXXR_SNDBX_TEM_ID ON [BLC_CAT_SEARCH_FACET_EXCL_XREF]
GO

DROP INDEX idx_BLSEFA_SNDBX_ID ON [BLC_SEARCH_FACET]
GO

DROP INDEX idx_BLSEFA_SNDBX_TEM_ID ON [BLC_SEARCH_FACET]
GO

ALTER TABLE [BLC_ALLOWED_ENUM_VALUE] ADD CONSTRAINT [PK__BLC_ALLO__ABA5F9BB3DAF5B78] PRIMARY KEY ([ALLOWED_ENUM_ID])
GO

ALTER TABLE [BLC_ASSET_FOLDER_ITEM_XREF] ADD CONSTRAINT [PK__BLC_ASSE__459A6D91D0E06A04] PRIMARY KEY ([ASSET_FOLDER_ITEM_XREF_ID])
GO

ALTER TABLE [BLC_ASSET_FOLDER_XREF] ADD CONSTRAINT [PK__BLC_ASSE__D781557F01358781] PRIMARY KEY ([ASSET_FOLDER_XREF_ID])
GO

ALTER TABLE [BLC_ASSET_FOLDER] ADD CONSTRAINT [PK__BLC_ASSE__DE2284B96B15F9C2] PRIMARY KEY ([ASSET_FOLDER_ID])
GO

ALTER TABLE [BLC_BOOST_RULE_CAT] ADD CONSTRAINT [PK__BLC_BOOS__B237DD2AC4A2842D] PRIMARY KEY ([BOOST_RULE_CAT_ID])
GO

ALTER TABLE [BLC_BOOST_RULE_GLOB] ADD CONSTRAINT [PK__BLC_BOOS__BAFA55211C94B138] PRIMARY KEY ([BOOST_RULE_GLOB_ID])
GO

ALTER TABLE [BLC_CONTENT_TGTR_CUST_SEG_XREF] ADD CONSTRAINT [PK__BLC_CONT__10653B3BAFD96542] PRIMARY KEY ([CONTENT_TGTR_CUST_SEG_XREF_ID])
GO

ALTER TABLE [BLC_CUSTOMER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [PK__BLC_CUST__15D1440F0CD1E162] PRIMARY KEY ([CUSTOMER_CUSTOMER_SEG_XREF_ID])
GO

ALTER TABLE [BLC_CUSTOMER_SEGMENT] ADD CONSTRAINT [PK__BLC_CUST__9F6AF532C2DA0B90] PRIMARY KEY ([CUSTOMER_SEGMENT_ID])
GO

ALTER TABLE [BLC_INDEX_FIELD] ADD CONSTRAINT [PK__BLC_INDE__2EAE7AAE24C632CD] PRIMARY KEY ([INDEX_FIELD_ID])
GO

ALTER TABLE [BLC_INDEX_FIELD_TYPE] ADD CONSTRAINT [PK__BLC_INDE__9DF57988775A2F5A] PRIMARY KEY ([INDEX_FIELD_TYPE_ID])
GO

ALTER TABLE [BLC_OFFER_CODE_RULE_MAP] ADD CONSTRAINT [PK__BLC_OFFE__1751392EFBB074BD] PRIMARY KEY ([OFFER_CODE_OFFER_CODE_RULE_ID])
GO

ALTER TABLE [BLC_OFFER_TEMPLATE] ADD CONSTRAINT [PK__BLC_OFFE__1BB45F21CD47EBF6] PRIMARY KEY ([OFFER_TEMPLATE_ID])
GO

ALTER TABLE [BLC_OFFER_DEP_FLD] ADD CONSTRAINT [PK__BLC_OFFE__51F76E37291C1E73] PRIMARY KEY ([OFFER_DEP_FLD_ID])
GO

ALTER TABLE [BLC_OFFER_CODE_RULE] ADD CONSTRAINT [PK__BLC_OFFE__ADD7EDA41ED976A2] PRIMARY KEY ([OFFER_CODE_RULE_ID])
GO

ALTER TABLE [BLC_OFFER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [PK__BLC_OFFE__F6FDE04C788F6BCD] PRIMARY KEY ([OFFER_CUSTOMER_SEGMENT_XREF_ID])
GO

ALTER TABLE [BLC_PRICE_LIST_CUST_SEG_XREF] ADD CONSTRAINT [PK__BLC_PRIC__EF66634FA98AC99B] PRIMARY KEY ([PRICE_LIST_CUST_SEG_XREF_ID])
GO

ALTER TABLE [BLC_PRODUCT_PRODUCT_GROUP_XREF] ADD CONSTRAINT [PK__BLC_PROD__011793CD68696E89] PRIMARY KEY ([PRODUCT_PRODUCT_GROUP_XREF_ID])
GO

ALTER TABLE [BLC_PRODUCT_GROUP] ADD CONSTRAINT [PK__BLC_PROD__D1152948B046DF71] PRIMARY KEY ([PRODUCT_GROUP_ID])
GO

ALTER TABLE [BLC_ASSET_FOLDER_XREF] ADD CONSTRAINT [FK102A01D7706F08F1] FOREIGN KEY ([PARENT_FOLDER_ID]) REFERENCES [BLC_ASSET_FOLDER] ([ASSET_FOLDER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_ASSET_FOLDER_XREF] ADD CONSTRAINT [FK102A01D7FE088EE3] FOREIGN KEY ([CHILD_FOLDER_ID]) REFERENCES [BLC_ASSET_FOLDER] ([ASSET_FOLDER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_PRICE_LIST_CUST_SEG_XREF] ADD CONSTRAINT [FK3902F48C2EF95B6A] FOREIGN KEY ([PRICE_LIST_ID]) REFERENCES [BLC_PRICE_LIST] ([PRICE_LIST_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_PRICE_LIST_CUST_SEG_XREF] ADD CONSTRAINT [FK3902F48CB8718EEC] FOREIGN KEY ([CUSTOMER_SEGMENT_ID]) REFERENCES [BLC_CUSTOMER_SEGMENT] ([CUSTOMER_SEGMENT_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_INDEX_FIELD_TYPE] ADD CONSTRAINT [FK4A310B72CBDA280B] FOREIGN KEY ([INDEX_FIELD_ID]) REFERENCES [BLC_INDEX_FIELD] ([INDEX_FIELD_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_SEARCH_FACET] ADD CONSTRAINT [FK4FFCC986BE3CE566] FOREIGN KEY ([INDEX_FIELD_TYPE_ID]) REFERENCES [BLC_INDEX_FIELD_TYPE] ([INDEX_FIELD_TYPE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

--ALTER TABLE [BLC_ALLOWED_ENUM_VALUE] ADD CONSTRAINT [FK5552E87062A47BC4] FOREIGN KEY ([FIELD_ID]) REFERENCES [BLC_CUSTOM_FIELD] ([FIELD_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
--GO

ALTER TABLE [BLC_CUSTOM_FIELD] ADD CONSTRAINT [FK5FF15FD23C3907C4] FOREIGN KEY ([FIELD_ID]) REFERENCES [BLC_FIELD] ([FIELD_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_BOOST_RULE_CAT] ADD CONSTRAINT [FK6F1E0F515D1A13D] FOREIGN KEY ([CATEGORY_ID]) REFERENCES [BLC_CATEGORY] ([CATEGORY_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_BOOST_RULE_CAT] ADD CONSTRAINT [FK6F1E0F5BE3CE566] FOREIGN KEY ([INDEX_FIELD_TYPE_ID]) REFERENCES [BLC_INDEX_FIELD_TYPE] ([INDEX_FIELD_TYPE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER] ADD CONSTRAINT [FK8F55F7B699291672] FOREIGN KEY ([OFFER_TEMPLATE_ID]) REFERENCES [BLC_OFFER_TEMPLATE] ([OFFER_TEMPLATE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_STORE] ADD CONSTRAINT [FK8F94D63BC13085DD] FOREIGN KEY ([ADDRESS_ID]) REFERENCES [BLC_ADDRESS] ([ADDRESS_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER_CODE_RULE_MAP] ADD CONSTRAINT [FK8FAD02C2446C7306] FOREIGN KEY ([OFFER_CODE_RULE_ID]) REFERENCES [BLC_OFFER_CODE_RULE] ([OFFER_CODE_RULE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER_CODE_RULE_MAP] ADD CONSTRAINT [FK8FAD02C29D28BF84] FOREIGN KEY ([BLC_OFFER_CODE_OFFER_CODE_ID]) REFERENCES [BLC_OFFER_CODE] ([OFFER_CODE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_INDEX_FIELD] ADD CONSTRAINT [FK9A53C1073C3907C4] FOREIGN KEY ([FIELD_ID]) REFERENCES [BLC_FIELD] ([FIELD_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_CUSTOMER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [FKB829E2CB7470F437] FOREIGN KEY ([CUSTOMER_ID]) REFERENCES [BLC_CUSTOMER] ([CUSTOMER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_CUSTOMER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [FKB829E2CBB8718EEC] FOREIGN KEY ([CUSTOMER_SEGMENT_ID]) REFERENCES [BLC_CUSTOMER_SEGMENT] ([CUSTOMER_SEGMENT_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_PRODUCT_PRODUCT_GROUP_XREF] ADD CONSTRAINT [FKC65750A15F11A0B7] FOREIGN KEY ([PRODUCT_ID]) REFERENCES [BLC_PRODUCT] ([PRODUCT_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_PRODUCT_PRODUCT_GROUP_XREF] ADD CONSTRAINT [FKC65750A1FBF5D076] FOREIGN KEY ([PRODUCT_GROUP_ID]) REFERENCES [BLC_PRODUCT_GROUP] ([PRODUCT_GROUP_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_ASSET_FOLDER_ITEM_XREF] ADD CONSTRAINT [FKCEE6478B46294CB2] FOREIGN KEY ([ASSET_ID]) REFERENCES [BLC_STATIC_ASSET] ([STATIC_ASSET_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_ASSET_FOLDER_ITEM_XREF] ADD CONSTRAINT [FKCEE6478B98CE5246] FOREIGN KEY ([FOLDER_ID]) REFERENCES [BLC_ASSET_FOLDER] ([ASSET_FOLDER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [FKD280E9DDB8718EEC] FOREIGN KEY ([CUSTOMER_SEGMENT_ID]) REFERENCES [BLC_CUSTOMER_SEGMENT] ([CUSTOMER_SEGMENT_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER_CUSTOMER_SEG_XREF] ADD CONSTRAINT [FKD280E9DDD5F3FAF4] FOREIGN KEY ([OFFER_ID]) REFERENCES [BLC_OFFER] ([OFFER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_BOOST_RULE_GLOB] ADD CONSTRAINT [FKD74C3819BE3CE566] FOREIGN KEY ([INDEX_FIELD_TYPE_ID]) REFERENCES [BLC_INDEX_FIELD_TYPE] ([INDEX_FIELD_TYPE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_CONTENT_TGTR_CUST_SEG_XREF] ADD CONSTRAINT [FKE87D242FB8718EEC] FOREIGN KEY ([CUSTOMER_SEGMENT_ID]) REFERENCES [BLC_CUSTOMER_SEGMENT] ([CUSTOMER_SEGMENT_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_CONTENT_TGTR_CUST_SEG_XREF] ADD CONSTRAINT [FKE87D242FBECA250D] FOREIGN KEY ([CONTENT_TARGETER_ID]) REFERENCES [BLC_CONTENT_TARGETER] ([CONTENT_TARGETER_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_OFFER_DEP_FLD] ADD CONSTRAINT [FKEE1F406599291672] FOREIGN KEY ([OFFER_TEMPLATE_ID]) REFERENCES [BLC_OFFER_TEMPLATE] ([OFFER_TEMPLATE_ID]) ON UPDATE NO ACTION ON DELETE NO ACTION
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP CONSTRAINT [FK4FFCC9863C3907C4]
GO

ALTER TABLE [BLC_FIELD_SEARCH_TYPES] DROP CONSTRAINT [FKF52D130D3C3907C4]
GO

DROP TABLE [BLC_FIELD_SEARCH_TYPES]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [ADDRESS_1]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [ADDRESS_2]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [APPLIES_TO_RULES]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [APPLIES_WHEN_RULES]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [APPLY_OFFER_TO_MARKED_ITEMS]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [ARCHIVED]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [CREATED_BY]
GO

ALTER TABLE [BLC_CUSTOM_FIELD] DROP COLUMN [CUSTOM_FIELD_ID]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [DATE_CREATED]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [DATE_UPDATED]
GO

ALTER TABLE [BLC_FIELD] DROP COLUMN [FACET_FIELD_TYPE]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [FIELD_ID]
GO

ALTER TABLE [BLC_CUSTOM_FIELD] DROP COLUMN [FRIENDLY_NAME]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [OFFER_DELIVERY_TYPE]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [PRICING_CONTEXT_RULE]
GO

ALTER TABLE [BLC_CUSTOM_FIELD] DROP COLUMN [SEARCHABLE]
GO

ALTER TABLE [BLC_FIELD] DROP COLUMN [SEARCHABLE]
GO

ALTER TABLE [BLC_CATEGORY] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CATEGORY_ATTRIBUTE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CATEGORY_MEDIA_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CATEGORY_PRODUCT_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CATEGORY_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CMS_MENU] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CMS_MENU_ITEM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CNTNT_TRGT_ACTION_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CNTNT_TRGT_ITEM_CRIT] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CNTNT_TRGT_RULES] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_ITEM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_TARGETER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_TARGETING_ACTION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_TARGET_RULE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_ZONE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CONTENT_ZONE_DEF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CON_ZONE_DEF_WDGT_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_DATA_DRVN_ENUM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_DATA_DRVN_ENUM_VAL] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_DYNAMIC_REGIONAL_FORM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_DYN_REG_FORM_FIELD] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_DYN_REG_FORM_FIELD_CAT] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_FLD_DEF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_FLD_GROUP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

--ALTER TABLE [BLC_FULFILLMENT_OPTION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
--GO

--ALTER TABLE [BLC_FULFILLMENT_PRICE_BAND] DROP COLUMN [SNDBX_APPROVAL_STATUS]
--GO

--ALTER TABLE [BLC_FULFILLMENT_WEIGHT_BAND] DROP COLUMN [SNDBX_APPROVAL_STATUS]
--GO

ALTER TABLE [BLC_INTERNATIONAL_MSG] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_MEDIA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER_CODE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER_ITEM_CRITERIA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER_RULE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER_RULE_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OFFER_TIER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OVERRIDE_CONTENT_ITEM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OVERRIDE_SC_FIELD] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_OVERRIDE_SC_ITEM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_ATTRIBUTES] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_FLD] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_ITEM_CRITERIA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_RULE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_TMPLT] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_TYPE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PAGE_TYPE_FLDDEF_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PGTMPLT_FLDGRP_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PL_CRITERIA_RULE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PL_RULE_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRICE_ADJUSTMENT] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRICE_LIST] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRICE_MODIFIER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_ATTRIBUTE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_CROSS_SALE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_FEATURED] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_OPTION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_OPTION_VALUE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_OPTION_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_PRODUCT_UP_SALE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_QUAL_CRIT_OFFER_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_CONTENT_ITEM_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_FLD] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_FLD_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_ITEM_CRITERIA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_RULE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_TYPE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SC_TYPE_WIDGET_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SEARCH_FACET_RANGE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SEARCH_FACET_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_ATTRIBUTE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_BNDL_ITM_PRC_DATA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_BUNDLE_ITEM] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_FEE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_MEDIA_MAP] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_OPTION_VALUE_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_PRICE_DATA] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SKU_PRICE_DATA_TIER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_SYSTEM_PROPERTY] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_TAR_CRIT_OFFER_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THEME_CONFIGURATION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THEME_DEFINITION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THEME_FILE] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THEME_FILE_PAGE_TYPE_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THEME_FLD] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_THMDEF_FLDGRP_XREF] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_TRANSLATION] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_URL_HANDLER] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_WIDGET] DROP COLUMN [SNDBX_APPROVAL_STATUS]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_ARCHIVED_FLAG]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_ARCHIVED_FLAG]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_CATALOG_FLAG]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_CATALOG_FLAG]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_DELETED_FLAG]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_DELETED_FLAG]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_ID]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_ID]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_ORIG_ITEM_ID]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_ORIG_ITEM_ID]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_ORIG_RECORD_ID]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_ORIG_RECORD_ID]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_TIER]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_TIER]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [SNDBX_TMPLT_RECORD_ID]
GO

ALTER TABLE [BLC_SEARCH_FACET] DROP COLUMN [SNDBX_TMPLT_RECORD_ID]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [STACKABLE]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [STORE_CITY]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [STORE_COUNTRY]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [STORE_PHONE]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [STORE_STATE]
GO

ALTER TABLE [BLC_STORE] DROP COLUMN [STORE_ZIP]
GO

ALTER TABLE [BLC_CAT_SEARCH_FACET_EXCL_XREF] DROP COLUMN [UPDATED_BY]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [USES]
GO

ALTER TABLE [BLC_OFFER] DROP COLUMN [USE_NEW_FORMAT]
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ALTER COLUMN [ATTR_NAME] [varchar](255) NULL
GO

ALTER TABLE [BLC_CONTENT_ZONE] ALTER COLUMN [CONTENT_ZONE_DEF] [numeric](19, 0) NULL
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ALTER COLUMN [CUSTOM_FIELD_TARGET] [varchar](255) NULL
GO

ALTER TABLE [BLC_CUSTOM_FIELD] ALTER COLUMN [CUSTOM_FIELD_TYPE] [varchar](255) NULL
GO