Qus:    What is the use of constraints in the SQL server?
Dec 04, 2020 16:29 DotNet 2 Answers Views: 1302 SWEETY

SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation between the constraint and the data action, the action is aborted.

Prev Next
Answers (2)
PARTH Dec 05, 2020 10:24
Answer:   SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation between the constraint and the data action, the action is aborted.

SAI Dec 05, 2020 14:48
Answer:   This constraints nothing but it will rule to enforce the rule on the table, like null constrinats , referential constriants , primarykey constriaints . If any of these rull will violate the rule , it will throws as error message.

Post Your Answer
Guest User

Not sure what solution is right for you?

Choose the right one for you.
Get the help of the experts and find a solution that best suits your needs.


Let`s Connect