Hi Guest
MobileUser
HomePage
Jobs
WalkIn
Articles
Agile
DotNet
WebServices
Mathematics
OOPS
WEB
SharePoint
Java
DataBase
Artificial Intelligence
BigData
Android
XML
Agile
Software
SEO
Science Techonlogy
Repository Questions
PHP
Frameworks
Server
Testing
HR
Java
TPF
Tutorial
Tools
Test and Papers
Silverlight
Science Techonlogy
----- Select Country -----
----- Select Location -----
----- Select Category -----
:) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
ASP.NET
:) Hot Jobs
:) Latest Articles
Follow
SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
Question Posted on 23 Nov 2021
Home
>>
DataBase
>>
SQL Query
>>
SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
SQL Query to disable or unable foreign key constraints temporarily by using TSQL?
There are certain conditions when we disable or unable foreign key or any other constraints on any table. After doing our operations just rollback the contraints on any of the SQL table:-
(1)Query to disable all table constraints
ALTER TABLE table_name NOCHECK CONSTRAINT ALL
(2)Query to enable all table constraints
ALTER TABLE table_name WITH CHECK CHECK CONSTRAINT ALL
(3)Query to disable single constraint
ALTER TABLE table_name NOCHECK CONSTRAINT constraint_name
(4)Query to enable single constraint
ALTER TABLE table_name WITH CHECK CHECK CONSTRAINT constraint_name
0
0
Input Your Comments Or suggestions(If Any)
Name
Email
(optional)
Comments
Other Important Questions
How to get the table count in last used query from cache by sending tablename?
Write a SQL query to print 1 to 100 in sql server?
Sql Interview Latest Query questions asked on 30 dec 2020
nth highest number from table
some good sql query
Top Searches:
asp net questions
vb net questions
sql query
uddl questions
class
javascript Questions
sharepoint interview questions and concept
silverlight questions and concept
wcf questions
beans
general knowledge
ajax questions
PHP
|
Biztalk
|
Testing
|
SAP
|
HR
|
Privacy policy |
Terms and Conditions
| Blog
If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
Home
About Us
GroupChat
Sitemap
Feedback
Contact us