12 docs tagged with "ddl"

Learn how to modify existing tables using the ALTER TABLE command. Add columns, drop columns, and change data types without losing data.

Learn how to create temporary tables for intermediate processing and how to copy tables for backup or testing purposes in SQL.

Learn how to create a new SQL database using the CREATE DATABASE command. Includes syntax for MySQL, SQL Server, and PostgreSQL with best practices.

Master the CREATE TABLE command. Learn how to define columns, data types, and primary keys to build the structure of your database.

Understand the difference between DROP, TRUNCATE, and DELETE. Learn when to use each command to remove tables or clear data efficiently.

Learn how to safely delete a database using the DROP DATABASE command. Understanding the risks and differences between DROP and Truncate.

Learn how to enforce data integrity in Oracle Database. Master Primary Keys, Foreign Keys, and business logic with CHECK constraints.

A complete guide to Oracle data types. Understand the difference between CHAR and VARCHAR2, and master NUMBER, DATE, and TIMESTAMP.

Learn how to use Sequences in Oracle Database to generate primary key values. Master CREATE, ALTER, and DROP SEQUENCE commands.

Master Oracle DDL. Learn how to create tables, manage identity columns, use virtual columns, and safely modify structures.

Learn how to use Oracle Temporary Tables for intermediate data processing. Understand the differences between Global and Private temp tables.

Learn how to manage the structure of your database using SQL DDL. Includes creating, altering, and dropping tables with data integrity.