Dear Sir/Madam
I have a MySQL database with lot of tables .
and I want to disable all the constraints from all the table at the
same time .How can i do it .And after do my work how can i enable all
the constraints again

harish saharan (harishksaharan (AT) gmail (DOT) com) writes:
If you have a MySQL database, comp.databases.mysql is over there. This
newsgroup is for SQL Server.

For SQL Server you can do:

SELECT 'ALTER TABLE ' + quotename(s.name) + '.' + quotename(o.name) +
' NOCHECK CONSTRAINT ALL'
FROM sys.objects o
JOIN sys.schemas s ON o.schema_id = s.schema_id
WHERE o.type = 'U'

Run this, copy results and paste into a query window.

To enable constraints again, change NOCHECK to WITH CHECK CHECK. (Yes,
that's two CHECK in a row.)

And, again, this is not a solution for MySQL.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx