以下的建表方法,能给数据表建立一个主键吗,帮我看看以下的sql语句:CREATE TABLE [dbo].[Tb_admins]
(
[ad_id] INT IDENTITY(1,1) NOT NULL,
[ad_name] NVARCHAR(20) DEFAULT('') NOT NULL,
[ad_faId] INT DEFAULT(0) NOT NULL,
[ad_pwd] NVARCHAR(100),
[ad_date] DATETIME DEFAULT(GETDATE())
CONSTRAINT [pk_ad_id] PRIMARY KEY CLUSTERED([ad_Id] ASC) WITH FILLFACTOR=90 ON [PRIMARY]
) ON [PRIMARY]
END
GO用了PRIMARY KEY CLUSTERED([ad_Id] ASC)以上的表列[ad_id]是主键吗?
难道还是要在[ad_id]后加PRIMARY KEY啊?
(
[ad_id] INT IDENTITY(1,1) NOT NULL,
[ad_name] NVARCHAR(20) DEFAULT('') NOT NULL,
[ad_faId] INT DEFAULT(0) NOT NULL,
[ad_pwd] NVARCHAR(100),
[ad_date] DATETIME DEFAULT(GETDATE())
CONSTRAINT [pk_ad_id] PRIMARY KEY CLUSTERED([ad_Id] ASC) WITH FILLFACTOR=90 ON [PRIMARY]
) ON [PRIMARY]
END
GO用了PRIMARY KEY CLUSTERED([ad_Id] ASC)以上的表列[ad_id]是主键吗?
难道还是要在[ad_id]后加PRIMARY KEY啊?
(
[ad_id] INT IDENTITY(1,1) NOT NULL,
[ad_name] NVARCHAR(20) DEFAULT('') NOT NULL,
[ad_faId] INT DEFAULT(0) NOT NULL,
[ad_pwd] NVARCHAR(100),
[ad_date] DATETIME DEFAULT(GETDATE())
CONSTRAINT [pk_ad_id] PRIMARY KEY CLUSTERED([ad_Id] ASC) WITH FILLFACTOR=90 ON [PRIMARY]
) ON [PRIMARY]GO多了個Endad_id是主健
CONSTRAINT [pk_ad_id] PRIMARY KEY CLUSTERED([ad_Id] ASC) 也可以在ad_Id后面加上就行
CONSTRAINT [pk_ad_id] PRIMARY KEY CLUSTERED
谢谢了哦
roy_88说得很对!