54 DDL (data definition language)
Data definition language (DDL) statements are Create, drop, alter statements. Database objects are created using create object statements, then stored in data dictionary of database. We can drop these objects using drop object statements. We can also alter these objects using alter object statements. Alter statements typically do not allow every change. According to database engine, we may have to drop the object and create it from the scratch. But most if database engine allows it alter statements are always more preferable and more performant.
The objects we could create again change according to database engine. Sqlite allows following common database objects:
- Tables
- Views
- Index
- Trigger
Sqlite also allows virtual tables but this virtual table is a bit different from the sql server and oracle versions.
In addition to above common objects, Sql Server and Oracle allows following common objects:
- Functions
- Procedures
- User
The sqlite does not need user object being a file-based database but oracle and sql server both require a user for database connection. Therefore, they have variety of commands to handle security, roles, and privileges for users.
These databases also allows creation of custom function and procedures.
For sqlite
You do not have to memorize their exact definition since most modern GUI tools help you to create these statements.
DBeaver Demo Create Table
DBeaver Demo Alter Table
DBeaver Demo Drop Table
DBeaver Demo Create View
DBeaver Demo Alter View
DBeaver Demo Drop View
Being an open source and free tool, DBeaver is not very powerful. But SQL Developer Oracle and Sql Server Management Studio allows creation, alteration and dropping of every object mentioned above using GUI tools.