SQL高手帮帮我...书上也有错误!?

来源：百度知道 编辑：UC知道 时间：2024/06/21 14:25:47
高手朋友们帮帮我,这两段代码我问过老师,说没问题,可是为什么就是提示错误?在此谢过了...
_____________________________________
数据库:filedb
_____________________________________
CREATE TABLE tblUser(
UserID VARCHAR(50) NOT NULL,
UserName VARCHAR(10) NOT NULL,
UserPassword VARCHAR(50) NOT NULL,
UserMail VARCHAR(50) NOT NULL,
UserType INTEGER DEFAULT(0),
UserCreated DATETIME DEFAULT(getdate()) NOT NULL
)
GO
CREATE INDEX PK_tblUser ON tblUser(UserID ASC)
GO
ALTER TABLE tblUser ADD CONSTRAINT PK_tblUser PRIMARY KEY(UserID)
GO
______________________________________
CREATE TABLE tblFile(
FileID BIGINT NOT NULL,
FileName VARCHAR(255) NOT NULL,
FilePath VARCHAR(255) NOT NULL,
FileType VARCHAR(10),
FileOwner VARCHAR(50) NOT NULL,
FileCreated DATETIME DEFAULT(getdate()) NOT NULL,
FileSubject VARCHAR(100) NOT NULL
)
GO
CREATE INDEX PK_tblFile ON tblFil

索引名和主键名重复冲突 必然要改一个 或是删去索引
最后面的ON DELETE RESTRICT
ON UPDATE RESTRICT实在调试不过,偶也不知道是什么,删掉吧

该删的帮你删了
CREATE TABLE tblUser(
UserID VARCHAR(50) NOT NULL,
UserName VARCHAR(10) NOT NULL,
UserPassword VARCHAR(50) NOT NULL,
UserMail VARCHAR(50) NOT NULL,
UserType INTEGER DEFAULT(0),
UserCreated DATETIME DEFAULT(getdate()) NOT NULL
)
GO
ALTER TABLE tblUser ADD CONSTRAINT PK_tblUser PRIMARY KEY(UserID)
GO
CREATE TABLE tblFile(
FileID BIGINT NOT NULL,
FileName VARCHAR(255) NOT NULL,
FilePath VARCHAR(255) NOT NULL,
FileType VARCHAR(10),
FileOwner VARCHAR(50) NOT NULL,
FileCreated DATETIME DEFAULT(getdate()) NOT NULL,
FileSubject VARCHAR(100) NOT NULL
)
GO
CREATE UNIQUE INDEX UIX_tblFile ON tblFile(FileOwner ASC)
GO
ALTER TABLE tblFile ADD CONSTRAINT PK_tblFile PRIMARY KEY(FileID)
GO
ALTER TABLE tblFile ADD CONSTRAINT FK_tblF