Question

SQL 默认约束的问题

下面这段代码在SQL Server 2008 下运行为什么总报“'for' 附近有语法错误”？

CREATE TABLE [dbo].[Students]
(
[SNO] [char](6) NOT NULL,
[SName] [nvarchar](10) NOT NULL,
[Nation] [nvarchar](10) NOT NULL,
CONSTRAINT S_PRIM PRIMARY KEY(SNO),
CONSTRAINT DEF_Nation DEFAULT '汉族' FOR [Nation],
);
GO

Answer 1

改成
CREATE TABLE [dbo].[Students]
(
[SNO] [char](6) NOT NULL,
[SName] [nvarchar](10) NOT NULL,
[Nation] [nvarchar](10) NOT NULL default '汉族',
CONSTRAINT S_PRIM PRIMARY KEY(SNO),
);
或者
CREATE TABLE [dbo].[Students]
(
[SNO] [char](6) NOT NULL,
CONSTRAINT S_PRIM PRIMARY KEY(SNO),
[SName] [nvarchar](10) NOT NULL,
[Nation] [nvarchar](10) NOT NULL,
);
alter table students
add constraint def_nation default '汉族' for nation

Answer 2

CONSTRAINT DEF_Nation DEFAULT '汉族' FOR [Nation],
语句后面的“，”去掉