Qus:    What is the use of constraints in the SQL server?
Dec 04, 2020 10:29 2 Answers Views: 84 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 04: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 08: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 course is right for you?

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


Let`s Connect