Create, Alter and Drop | DDL

Data Definition Language

In this section, we will learn how to make use of CREATE, ALTER and DROP statements to change the database structure.

DDL stands for Data Definition Language that is used to create or alter the database schema and define constraints. DDL statements represent the definition of data structures. It is declarative and can be used to define tables, views, indexes, name spaces, table spaces, databases, stored procedures and functions, triggers and users.

Objects can be created using CREATE and deleted using DROP. GRANT and REVOKE are statements used to add access privileges and remove them respectively. ALTER is used to modify created object's properties.

We will learn more about in the upcoming sections:

  • PostgreSQL CREATE
  • ALTER tables, columns, primary keys
  • CREATE AND ALTER Sequences and increments
  • ALTER Constraints

Get Started with GraphQL Now

Hasura Cloud gives you a fully managed, production ready GraphQL API as a service to help you build modern apps faster.
Ready to get started?
Start for free on Hasura Cloud or you could contact our sales team for a detailed walk-through on how Hasura may benefit your business.
Stay in the know
Sign up for full access to our community highlights, new features, and occasional baby animal gifs! Oh, and we have a strict no-spam rule. ✌️