Xqe8xgBr

1USE [ZOOM_STG] 
2GO
3
4IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ITAM_ESL_TEMP_1]') AND type in (N'U'))
5
6DROP TABLE [dbo].[ITAM_ESL_TEMP_1]
7
8GO
9
10CREATE TABLE [dbo].[ITAM_ESL_TEMP_1]
11 	(
12	ITAM_ESL_STG_ID [int] IDENTITY(1,1) NOT NULL,
13	[Business_ID] [nvarchar](768) NOT NULL,
14	[Business_Code] [nvarchar](1020) NULL,
15	[Bussiness_Name] [nvarchar](400) NULL,
16	[Bussiness_Region] [nvarchar](400) NOT NULL,
17	[Bussiness_Subregion] [nvarchar](100) NULL,
18	[Bussiness_Country] [nvarchar](120) NULL,
19	[Bussiness_Industry] [nvarchar](100) NULL,
20	[Bussiness_Role] [nvarchar](200) NULL,
21	[Bussiness_Role_Comment] [nvarchar](1500) NULL,
22	[Bussiness_Person_ID] [nvarchar](16) NULL,
23	[Bussiness_Person_Name] [nvarchar](202) NULL,
24	[Bussiness_Person_Email] [nvarchar](800) NULL,
25	[Bussiness_Person_Phone] [nvarchar](100) NULL,
26	[Bussiness_Person_Mobile] [nvarchar](100) NULL,
27	[Loading_Status] [int] NULL,
28	[Created_Dt] [datetime] NOT NULL CONSTRAINT [DF_ITAM_ESL_CREATED_DT_1]  DEFAULT (getdate()),
29	[Created_User_Id] int NOT NULL,
30	[Last_Updated_Dt] [datetime] NOT NULL CONSTRAINT [DF_ITAM_ESL_LAST_UPDATED_DT_1]  DEFAULT (getdate()),
31	[Last_Updated_User_Id] [int] NOT NULL,
32	[Deleted_Flg] [nvarchar] (1) NOT NULL CONSTRAINT [DF_ITAM_ESL_STAGING_DELETED_FLG_1]  DEFAULT ('N')
33	CONSTRAINT [PK_ITAM_ESL_STG_1] PRIMARY KEY CLUSTERED
34	   (
35	     [ITAM_ESL_STG_ID] ASC
36       )
37) ON [PRIMARY]