2010-01-03, 17:35
#1
Jo jag sitter och kollar lite på sql och skriver ett query som inte sammankopplas när jag gör ett nytt diagram. Alltså dessa foreign key constraints visas inte.
Jag sitter i miljön sql server express 2005 med MS SQL Server Management Studio Express.
Jag sitter i miljön sql server express 2005 med MS SQL Server Management Studio Express.
Kod:
ALTER TABLE registration
DROP CONSTRAINT FK_StudentID
IF OBJECT_ID('Student', 'U') IS NOT NULL
DROP TABLE Student;
CREATE TABLE Student
( StudentID INT IDENTITY(100,1)PRIMARY KEY CLUSTERED
, FirstName VARCHAR (25) NOT NULL
, LastName VARCHAR (25) NOT NULL
, Gender VARCHAR (1) NOT NULL
, GPA FLOAT)
ALTER TABLE registration
DROP CONSTRAINT FK_SubjectID
IF OBJECT_ID('Subject', 'U') IS NOT NULL
DROP TABLE Subject;
CREATE TABLE Subject
( SubjectID INT IDENTITY(200,1)PRIMARY KEY CLUSTERED
, SubjectName VARCHAR (15) NOT NULL
, Description VARCHAR (25) NOT NULL
, Credits INT NOT NULL
, CONSTRAINT UNQ_SubjectName UNIQUE (subjectName))
IF OBJECT_ID('Student', 'U') IS NOT NULL
DROP TABLE Registration;
CREATE TABLE Registration
( RegistrationID INT IDENTITY(500,1)PRIMARY KEY CLUSTERED
, StudentID INT NOT NULL
, SubjectID INT NOT NULL
, GradeID VARCHAR (2)
, Status VARCHAR(1) NOT NULL
, CONSTRAINT FK_StudentID FOREIGN KEY (StudentID) REFERENCES Student (StudentID)
, CONSTRAINT FK_SubjectID FOREIGN KEY (SubjectID) REFERENCES Subject (SubjectID))
