2023年7月13日发(作者：)

SQL语句新建表，同时添加主键、索引、约束SQL语句新建数据表 主键，索引，约束CREATE TABLE [dbo].[T_SendInsideMessageRec]( [SendInsideMID] [uniqueidentifier] NOT NULL, [ReceiveMobile] [nvarchar](20) NULL, [SendTime] [datetime] NULL, [Content] [nvarchar](200) NULL, [result] [nvarchar](100) NULL, [remark] [nvarchar](100) NOT NULL, CONSTRAINT [PK_T_SendInsideMessageRec] PRIMARY KEY NONCLUSTERED

( [SendInsideMID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_SendInsideMID] DEFAULT (newid()) FOR [SendInsideMID]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_ReceiveMobile] DEFAULT ('') FOR [ReceiveMobile]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_SendTime] DEFAULT (getdate()) FOR [SendTime]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_Content] DEFAULT ('') FOR [Content]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_result] DEFAULT ('') FOR [result]GOALTER TABLE [dbo].[T_SendInsideMessageRec] ADD CONSTRAINT [DF_T_SendInsideMessageRec_remark] DEFAULT ('') FOR [remark]GO