Question on constrains
I have two databases I am trying to sync with RedGate's SQL Compare.
Objects such as tables have slight differences and thats OK, but one database has one constrain in that object and another has a different constrain in the same object. Don't ask me why.
Question: What happens if I drop the constrains on both databases so I can run my sync ?
Question: Is there a way to drop ALL constrains in all tables of a database, if so .. how ? if not, how do I drop constrains from one table ?
Question: What could happen if I drop constrins from one table
My constrains look something similar to:
ALTER TABLE [dbo].[Cases] ADD PRIMARY KEY NONCLUSTERED ([Id])
GO
or
ALTER TABLE [dbo].[LawFirm] ADD PRIMARY KEY CLUSTERED ([FirmId])
GO
I am using MS SQL 2008 Server
Objects such as tables have slight differences and thats OK, but one database has one constrain in that object and another has a different constrain in the same object. Don't ask me why.
Question: What happens if I drop the constrains on both databases so I can run my sync ?
Question: Is there a way to drop ALL constrains in all tables of a database, if so .. how ? if not, how do I drop constrains from one table ?
Question: What could happen if I drop constrins from one table
My constrains look something similar to:
ALTER TABLE [dbo].[Cases] ADD PRIMARY KEY NONCLUSTERED ([Id])
GO
or
ALTER TABLE [dbo].[LawFirm] ADD PRIMARY KEY CLUSTERED ([FirmId])
GO
I am using MS SQL 2008 Server
lcohan
You could get duplicate ID's and that's not good from data integrity point of view.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What would i need to do to drop one specific constrain ?
Not a key, but another constrain, such as:
-- Foreign Keys
ALTER TABLE [dbo].[ActivityParties] WITH NOCHECK ADD FOREIGN KEY ([activity_id]) REFERENCES [dbo].[Activities] ([ActivityId]) ON DELETE CASCADE
GO
Also,
What is the difference between a 'clustered' and a nonclustered key ?
ADD PRIMARY KEY CLUSTERED
Not a key, but another constrain, such as:
-- Foreign Keys
ALTER TABLE [dbo].[ActivityParties] WITH NOCHECK ADD FOREIGN KEY ([activity_id]) REFERENCES [dbo].[Activities] ([ActivityId]) ON DELETE CASCADE
GO
Also,
What is the difference between a 'clustered' and a nonclustered key ?
ADD PRIMARY KEY CLUSTERED
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
to drop constraints, you simply do
alter table <table> drop constraint <constraint name>
alter table <table> drop constraint <constraint name>
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.