通過SQL腳本設置主鍵、自增列、默認值
來源：程序員人生 發布時間：2014-02-03 03:17:05 閱讀次數：2881次
自增列：[PID] [int] IDENTITY (1, 1) NOT NULL
設置主鍵：這里的PK_t_LockDataNet前綴PK_不好理解，呵呵。
ALTER TABLE hyoa_SysInfo..t_LockDataNet ADD CONSTRAINT
PK_t_LockDataNet PRIMARY KEY CLUSTERED
(
PID
) ON [PRIMARY];
設置默認值：DF_t_LockDataNet_TotalNum前綴DF_表名_字段名
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
生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
