# SQL DDL Differences between Hive and Trino(Presto)

Data Definition Language (DDL) is a concept in SQL that can be used to create and modify the structure of database objects or schema objects. You can use DDL statements to create, manage, and delete tables, indexes, users, and other schema objects.

As it pertains to data-processing, Trino(Presto) is optimized for quickly processing smaller volumes of information while Hive is better for querying more expansive databases requiring large amounts of memory. Both Hive and Trino(Presto) use DDL commands but in slightly different ways.

The following table illustrates DDL commands required for Hive and Trino(Presto).

**SQL DDL Commands and Their Equivalents**

| SQL DDL Commands | Hive SQL DDL | Trino(Presto) SQL DDL | Query Definition |
|  --- | --- | --- | --- |
| ALTER | ALTER | ALTER | Modifies the structure of an existing table. |
| CREATE | CREATE | CREATE | Creates a database or objects including tables, views, stored procedures, etc. |
| DROP | DROP | DROP | Deletes an existing database or an object within a database. |
| TRUNCATE | TRUNCATE | DELETE | Removes all the records from a table. |