Interview Questions and Answers
How to Truncate Table? What challenges we can face while doing this?
You cannot truncate objects that have child tables, you would have to first drop the foriegn key and then truncate the parent table and then put the foriegn key back in place.
Foreign Key constraints between columns in the same table are permitted.
Post a Comment
0 Comments