Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN TRAN;
- CREATE TABLE A (PKey int NOT NULL IDENTITY, NewFieldKey int NULL, CONSTRAINT PK_A PRIMARY KEY (PKey));
- CREATE INDEX A_2 ON A (NewFieldKey);
- CREATE TABLE B (PKey int NOT NULL IDENTITY, CONSTRAINT PK_B PRIMARY KEY (PKey));
- ALTER TABLE A ADD CONSTRAINT FK_B_A FOREIGN KEY (NewFieldKey) REFERENCES B (PKey);
- COMMIT TRAN;
Add Comment
Please, Sign In to add comment