ETL_DWH_ARI/schema/GC_TRANSIT_ARI/tables/import.Address.sql

CREATE TABLE [import].[Address] (
   [timestamp] [timestamp] NOT NULL,
   [Address No_] [int] NOT NULL,
   [Name] [varchar](100) NOT NULL,
   [Last Name] [varchar](100) NOT NULL,
   [First Name] [varchar](50) NOT NULL,
   [Address] [varchar](100) NOT NULL,
   [Post Code] [varchar](20) NOT NULL,
   [City] [varchar](50) NOT NULL,
   [Country Code] [varchar](10) NOT NULL,
   [Phone No_] [varchar](50) NOT NULL,
   [E-Mail] [varchar](100) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Address$0] PRIMARY KEY CLUSTERED ([Address No_], [Client_DB])
)

CREATE UNIQUE NONCLUSTERED INDEX [$1] ON [import].[Address] ([Name], [Address No_], [Client_DB])
CREATE UNIQUE NONCLUSTERED INDEX [$4] ON [import].[Address] ([Last Name], [First Name], [Address No_], [Client_DB])
CREATE UNIQUE NONCLUSTERED INDEX [$5] ON [import].[Address] ([First Name], [Address No_], [Client_DB])
CREATE UNIQUE NONCLUSTERED INDEX [$6] ON [import].[Address] ([Last Name], [Address No_], [Client_DB])

GO