Project

General

Profile

FILE 2.txt

Truong Nguyen Vu, 09/14/2020 09:40 AM

 
1
CREATE TABLE [dbo].[CM_DVDM_KHOI](
2
	[ID] [INT] IDENTITY(1,1) NOT NULL,
3
	[DVDM_ID] [VARCHAR](20) NULL,
4
	[KHOI_ID] [VARCHAR](20) NULL,
5
 CONSTRAINT [PK_CM_DVDM_KHOI] PRIMARY KEY CLUSTERED 
6
(
7
	[ID] ASC
8
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
9
) ON [PRIMARY]
10

    
11
CREATE TABLE [dbo].[CM_HANGHOA_DVCM](
12
	[ID] [INT] IDENTITY(1,1) NOT NULL,
13
	[HH_ID] [VARCHAR](15) NULL,
14
	[DVCM_ID] [VARCHAR](15) NULL,
15
 CONSTRAINT [PK_CM_HANGHOA_DVCM] PRIMARY KEY CLUSTERED 
16
(
17
	[ID] ASC
18
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
19
) ON [PRIMARY]