Posted by Roy Harvey (SQL Server MVP) on 10/30/07 11:54

On Tue, 30 Oct 2007 10:35:08 -0000, cong <franzcai80@gmail.com> wrote:

>IS_ORIGIONAL bit NOT NULL,
>CONSTRAINT DF_BBSItem_IS_ORIGIONAL DEFAULT(0),
>AUTHOR nvarchar(15) COLLATE Chinese_PRC_CS_AS NOT NULL,

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

A constraint that comes after a comma is a table constraint. Table
constraints must be specified AFTER all the columns. Since this is a
DEFAULT constraint that must be associated with a column remove the
comma and make it a column constraint.

>BROWSED_TIMES smallint NOT NULL
>CONSTRAINT DF_BBSItem_BROWSED_TIMES DEFAULT(0),
>LATEST_REPLICATION_ID int NULL

When you get past that you will find that CLUSTERD is not the correct
spelling of the keyword CLUSTERED. And you might prefer to spell
ORIGIONAL as ORIGINAL, and if REPLYD is supposed to be the past tense
of REPLY then you might want REPLYED.

Roy Harvey
Beacon Falls, CT

• Next in forum: Re: CONTAINS and wildcard
• Prev in forum: Re: Error message on using union statement with order by using reserved words
• Thread view: Re: some error in table definition

[Reply to this message]