CREATE TABLE marks ( id idType identity not null primary key, studentID int not null FOREIGN KEY REFERENCES student(id) ON UPDATE CASCADE, marks int CHECK(marks >=0 and marks <= 100) )
ALTER TABLE marks ALTER COLUMN studentID ON DELETE NO ACTION AlTER TABLE marks DROP FOREIGN KEY studentID
ALTER TABLE marks DROP CONSTRAINT [marks_studentID_FK]; ALTER TABLE marks DROP COLUMN studentID ;
marks_studentID_FK
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)