SQL Constraints fits as DML or as DDL?

Question

SQL Constraints fits as DML or as DDL?

Navigation

#1 by (3 votes)

1

DDL - Data definition language: is used to create and change tables (CREATE, ALTER, etc.), right?

DML - Data manipulation language: is used for data manipulation of tables (INSERT, UPDATE, DELETE, SELECT).

Do CONSTRAINTS fall into the DDL category?

sql-server constraint

asked by anonymous 22.02.2018 / 17:08

1 answer

Load a Dropdownlist based on an enum - Asp.net core UML - Class Diagram [closed]

score 3 · Accepted Answer

3

Yes, the contraints fall into this category. They are used in creating tables to ensure rules about the fields you are creating, an example is primary key or null support.

22.02.2018 / 17:23