sql Server利用其create脚本来创建表

 1 -- 这是依据系统自动生成的create脚本，填入所需字段来创建表
 2 
 3 USE [csnprod]
 4 GO
 5 
 6 /****** Object:  Table [dbo].[message_master]    Script Date: 2023/8/25 12:57:06 ******/
 7 SET ANSI_NULLS ON
 8 GO
 9 
10 SET QUOTED_IDENTIFIER ON
11 GO
12 
13 SET ANSI_PADDING ON
14 GO
15 -- 创建主表：主键、所需字段、创建人和修改人
16 CREATE TABLE [dbo].[mes_master](
17     [mes_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
18 
19     [mes_title] [varchar](50) NOT NULL,
20     [mes_grade] [varchar](20) NOT NULL,
21 
22     [create_user] [varchar](20) NOT NULL,
23     [create_time] [datetime] NOT NULL,
24 
25     [trans_user] [varchar](20) NOT NULL,
26     [trans_time] [datetime] NOT NULL,
27  CONSTRAINT [PK_mes_master] PRIMARY KEY CLUSTERED 
28 (
29     [mes_id] ASC
30 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
31 ) ON [PRIMARY]
32 
33 GO
34 ---------------------------------------------------------------------------------------------
35 ---------------------------------------------------------------------------------------------
36 SET ANSI_PADDING OFF
37 GO
38 
39 -- 明细表：有自己的主键、与主表有同名关联字段、所需字段、创建人和修改人
40 CREATE TABLE [dbo].[mes_details](
41     [id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
42 
43     [mes_id] [numeric](18, 0) NOT NULL,
44 
45     [mes_notifier] [varchar](50) NOT NULL,
46     [noti_department] [varchar](20) NOT NULL,
47 
48     [create_user] [varchar](20) NOT NULL,
49     [create_time] [datetime] NOT NULL,
50 
51     [trans_user] [varchar](20) NOT NULL,
52     [trans_time] [datetime] NOT NULL,
53  CONSTRAINT [PK_mes_details] PRIMARY KEY CLUSTERED 
54 (
55     [id] ASC
56 )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
57 ) ON [PRIMARY]
58 
59 GO
60 
61 SET ANSI_PADDING OFF
62 GO