WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT

by

The first syntax is redundant – the WITH CHECK is default for new constraints, and the constraint is turned on by default as well.

This syntax is generated by the SQL management studio when generating sql scripts — I’m assuming it’s some sort of extra redundancy, possibly to ensure the constraint is enabled even if the default constraint behavior for a table is changed.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. How do I UPDATE from a SELECT in SQL Server?
  3. Get top 1 row of each group
  4. How to return only the Date from a SQL Server DateTime datatype
  5. How to calculate age (in years) based on Date of Birth and getDate()
  6. CROSS JOIN vs INNER JOIN in SQL
  7. Referring to a Column Alias in a WHERE Clause
  8. Function vs. Stored Procedure in SQL Server
  9. converting Epoch timestamp to sql server(human readable format)
  10. How to get difference between two rows for a column field?
  11. How do I split a delimited string so I can access individual items?
  12. Common Table Expression, why semicolon?
  13. What’s the best way to select the minimum value from several columns?
  14. T-SQL split string based on delimiter
  15. Counting DISTINCT over multiple columns
  16. SQL Server SELECT into existing table
  17. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  18. Why use Select Top 100 Percent?
  19. How to check if a stored procedure exists before creating it
  20. Correct use of transactions in SQL Server
  21. How do I prevent a database trigger from recursing?
  22. What is the Null Character literal in TSQL?
  23. SQL Server : SUM() of multiple rows including where clauses
  24. Executing SQL Server Agent Job from a stored procedure and returning job result
  25. how does SELECT TOP works when no order by is specified?
  26. Cumulative Total in MS Sql server [duplicate]
  27. SQL can I have a “conditionally unique” constraint on a table?
  28. SUM total time in SQL Server [duplicate]
  29. Memory effective way to read BLOB data in C#/SQL 2005
  30. How to insert Arabic characters into SQL database?

Leave a Comment