0 - 2 of 2 tags for Foreign
An owner referenced by user does not have REFERENCES access

Hi,
 
I'm logged in with dbc user.
I'm ALTERing a table to add Foreign Key Constraint with Following statement
ALTER TABLE testdb.Master2 ADD CONSTRAINT fk_Master1 FOREIGN KEY (Master1ID) REFERENCES testdb.Master1(Master1ID);
its works fine.
But when i write this in a procedure

By parthmalhan, 07 Oct 2014 | Tagged: Foreign key Constraint database index primary alter table | 5 comments
Temporary Disable\enable Constraints (Foreign Key, Check Constriant, Unique Key)

Hi,
 
I want to Update a table. But before that i want disable foreign key\check Constraint\Unique Key on some tables.
After update, i want to enable those disables constraint again.
 
Can you please tell me how can i do that.
 
Parth

By parthmalhan, 23 Sep 2014 | Tagged: teradata database Constraint primary key Foreign Unique Check alter | 13 comments