text: ﻿ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [BusinessUnit]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Building]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Address1]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Address2]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [TownOrCity]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [PostalCode]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Region]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Country]
  ALTER TABLE [Lookup].[UnitedKingdomCompetentAuthority] DROP COLUMN [Telephone]
  
  GO