SQL Constraints fits as DML or DDL?

Asked

Viewed 91 times

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 answer

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

You are not signed in. Login or sign up in order to post.