zPjVL4YU

1--GO
2
3    CREATE TABLE [dbo].[tableA] (
4        [ID]     INT NOT NULL,
5        [IsRecal] BIT NULL,
6        PRIMARY KEY CLUSTERED ([ID] ASC) ON [PRIMARY]
7    ) ON [PRIMARY];
8
9
10    --GO
11
12
13    CREATE TABLE [dbo].[tableB] (
14        [ID]     INT NOT NULL,
15        [ABC] BIT NULL,
16        PRIMARY KEY CLUSTERED ([planeNum] ASC) ON [PRIMARY]
17    ) ON [PRIMARY];
18
19
20    --GO
21	
22--GO
23
24    IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'tableA')
25    DROP TABLE [dbo].[tableA]
26    --GO
27
28    CREATE TABLE [dbo].[tableA] (
29        [ID]     INT NOT NULL,
30        [Iscal] BIT NULL,
31        PRIMARY KEY CLUSTERED ([ID] ASC) ON [PRIMARY]
32    ) ON [PRIMARY];
33
34    --GO
35
36    IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = N'tableB')
37    DROP TABLE [dbo].[tableB]
38    --GO
39
40    CREATE TABLE [dbo].[tableB] (
41        [Num]     INT NOT NULL,
42        [IsAdd] BIT NULL,
43        PRIMARY KEY CLUSTERED ([Num] ASC) ON [PRIMARY]
44    ) ON [PRIMARY];