code_junkie

Wrap an Oracle schema update in a transaction

Nov 10th, 2011
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. BEGIN TRAN;
  2.  
  3. CREATE TABLE A (PKey int NOT NULL IDENTITY, NewFieldKey int NULL, CONSTRAINT PK_A PRIMARY KEY (PKey));
  4. CREATE INDEX A_2 ON A (NewFieldKey);
  5. CREATE TABLE B (PKey int NOT NULL IDENTITY, CONSTRAINT PK_B PRIMARY KEY (PKey));
  6. ALTER TABLE A ADD CONSTRAINT FK_B_A FOREIGN KEY (NewFieldKey) REFERENCES B (PKey);
  7.  
  8. COMMIT TRAN;
Add Comment
Please, Sign In to add comment