SQL语句求解释，总是提示有错
use [register]
go
create table[dbo].[Register]
(
[id][int]identity(1,1)not null,
[username][nvarchar](50)collate chinese_prc_ci_as null,
[password][nvarchar](50)collate chinese_prc_ci_as null,
[sex][int]null,
[picture][nvarchar](50)collate chinese_prc_ci_as null,
[IM][nvarchar](50)collate chinese_prc_ci_as null,
[information][nvarchar](50)collate chinese_prc_ci_as null,
[others][nvarchar](50)collate chinese_prc_ci_as null,
[ifisuser][int]null,
constrain[PK_Register]primary key clustered
(
[id]asc
)
with(pad_index = OFF,
statistics_norecompute = off,
ignore_dup_key = off,
allow_row_locks = on,
allow_page_locks = on)on[primary]
)on[primary]

[解决办法]