some error in table definition

if exists(select * from dbo.sysobjects where id =
object_id(N'BBSItems')
and OBJECTPROPERTY(id,N'IsUserTable')=1)
drop table BBSItems
GO

CREATE TABLE BBSItems(
ITEM_ID int IDENTITY(1,1) NOT NULL,
ITEM_TITLE nvarchar(30) COLLATE Chinese_PRC_CS_AS NOT NULL,
ITEM_CONTENT nvarchar(3000) COLLATE Chinese_PRC_CS_AS NOT NULL,
COMPOSE_DATE smalldatetime NOT NULL,
MODIFY_DATE smalldatetime NULL,
IS_ORIGIONAL bit NOT NULL,
CONSTRAINT DF_BBSItem_IS_ORIGIONAL DEFAULT(0),
AUTHOR nvarchar(15) COLLATE Chinese_PRC_CS_AS NOT NULL,
FARTHER_ID int NULL,
REPLYD_TIMES smallint NOT NULL
CONSTRAINT DF_BBSItem_REPLYD_TIMES DEFAULT(0),
BROWSED_TIMES smallint NOT NULL
CONSTRAINT DF_BBSItem_BROWSED_TIMES DEFAULT(0),
LATEST_REPLICATION_ID int NULL,
CONSTRAINT PK_BBSItem PRIMARY KEY CLUSTERD
(
ITEM_ID
) ON PRIMARY,
CONSTRAINT FK_BBSItem_BBSItem1 FOREIGN KEY
(
LATEST_REPLICATION_ID
)REFERENCES BBSItems(
ITEM_ID),
CONSTRAINT FK_BBSItem_UserInfo FOREIGN KEY
(
AUTHOR
)REFERENCES useinfo(nickname)
)
ON PRIMARY
GO

row 9:ITEM_CONTENT nvarchar(3000) COLLATE Chinese_PRC_CS_AS NOT NULL,
constraint 'TABLE' definition wrong in gramma。

can you help me?

.

Relevant Pages

  • Re: Suche mit Wildcards - inverser Key
    ... hier die Tabellenstruktur inklusive Indexe und Trigger ... CONSTRAINT PRIMARY KEY NONCLUSTERED ...
    (microsoft.public.de.sqlserver)
  • Problem merging two queries
    ... CONSTRAINT PRIMARY KEY CLUSTERED ... REFERENCES ( ... CONSTRAINT FOREIGN KEY ...
    (microsoft.public.sqlserver.programming)
  • RE: udf in computed column
    ... > EmployeeTypeId INT NOT NULL, ... > CONSTRAINT PK_EmployeeTypes PRIMARY KEY NONCLUSTERED ... > EmployeeId INT NOT NULL, ... > Created DATETIME NOT NULL DEFAULT), ...
    (microsoft.public.sqlserver.programming)
  • udf in computed column
    ... EmployeeTypeId INT NOT NULL, ... CONSTRAINT PK_EmployeeTypes PRIMARY KEY NONCLUSTERED ... EmployeeId INT NOT NULL, ... AbsenceTypeId INT NOT NULL, ...
    (microsoft.public.sqlserver.programming)
  • Re: A Generic Generics Problem
    ... struct MySumwhere T: struct, ... public static T AddInteger(T value, ... > the TypeConverter. ... >>> constraint language details). ...
    (microsoft.public.dotnet.languages.csharp)