1
DDL - Data Definition language: is used to create and change tables (CREATE, ALTER, etc.), right?
DML - Data Manipulation language: is used for handling table data (INSERT, UPDATE, DELETE, SELECT).
CONSTRAINTS fall into the DDL category?
1
DDL - Data Definition language: is used to create and change tables (CREATE, ALTER, etc.), right?
DML - Data Manipulation language: is used for handling table data (INSERT, UPDATE, DELETE, SELECT).
CONSTRAINTS fall into the DDL category?
2
Yes, contraints are part of that category. They are used to create tables to ensure rules about the fields you are creating, an example is primary key or null support.
Browser other questions tagged sql-server constraint
You are not signed in. Login or sign up in order to post.
Doesn’t look like DML to me
– Jefferson Quesado