· 6 years ago · Dec 23, 2019, 12:22 PM
1USE StudyDBSPA
2DROP TABLE IF EXISTS DbTempInfo
3CREATE TABLE DbTempInfo (
4 ID INT NOT NULL IDENTITY(1,1)
5 CONSTRAINT PK_DbTempInfo PRIMARY KEY CLUSTERED,
6 DbName VARCHAR(1023) NOT NULL UNIQUE
7 CHECK (LEN(DbName) <> 0),
8 SubjectID INT NOT NULL
9 CONSTRAINT FK_DbTempInfo_DbSubjects FOREIGN KEY REFERENCES DbSubjects(ID),
10 CreatedTime DATETIME NOT NULL,
11 IsDeleted BIT NOT NULL
12)