Auto-increment column: [PID] [int] IDENTITY (1, 1) NOT NULL
Set the primary key: The PK_t_LockDataNet prefix pk_is hard to understand.
Alter table hyoa_SysInfo .. t_LockDataNet ADD CONSTRAINT
PK_t_LockDataNet PRIMARY KEY CLUSTERED
(
PID
) ON [PRIMARY];
Set the default value: DF_t_LockDataNet_TotalNum prefix DF _ TABLE name_field name
Alter table hyoa_SysInfo .. t_LockDataNet ADD
CONSTRAINT [DF_t_LockDataNet_TotalNum] DEFAULT (5) FOR [TotalNum],
CONSTRAINT [DF_t_LockDataNet_DataTime] DEFAULT (getdate () FOR [DataTime]
GO
Create table hyoa_SysInfo .. t_LockDataNet (
[PID] [int] IDENTITY (1, 1) not null,
[TotalNum] [int] NULL,
[ProList] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL,
[DataTime] [datetime] NULL,
[PFlag] [bit] NULL,
[NodeName] [varchar] (225) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
Alter table hyoa_SysInfo .. t_LockDataNet ADD CONSTRAINT
PK_t_LockDataNet PRIMARY KEY CLUSTERED
(
PID
) ON [PRIMARY];
Alter table hyoa_SysInfo .. t_LockDataNet ADD
CONSTRAINT [DF_t_LockDataNet_TotalNum] DEFAULT (5) FOR [TotalNum],
CONSTRAINT [DF_t_LockDataNet_DataTime] DEFAULT (getdate () FOR [DataTime]
GO