May 13, 2009 at 1:49 pm
If I remember correctly, this is a simple matter of which was created first.
In the first set, the FK was added after the database was created, hence the need to add the second part to actually perform the check constraint against the existing data. In the second database, it was probably created from scripting the first database and there fore no need to check data as it does not exist yet.
All you did when you manually tried to correct this is tell SQL to check the data using the constraint.
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
May 14, 2009 at 1:54 am
aha...ok...
So, it's there a way to make them look alike?because I want them to be the same structurally, when I compare them with Apex Sql to see no difference.Is this possible, or they will remain the same?
Thanks for the response
May 14, 2009 at 5:24 am
unfortunately, the commands that were used to create the database (ie History) are stored in Master. This is what you are seeing when you query the design. The only way I know would be to drop and recreate the database.
Raymond Laubert
Exceptional DBA of 2009 Finalist
MCT, MCDBA, MCITP:SQL 2005 Admin,
MCSE, OCP:10g
May 14, 2009 at 7:03 am
Ok
I really didn't know how to deal with this, and I'm glad I know the answer
Thanks a lot
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply