DBAS Week 5 Notes: Intro to DDL & DML

Learning Goals:

• Be able to define “Data Definition Language (DDL)”

• Create basic tables

• Select correct data types

• Define constraints

• Modify tables

• Create tables based on an existing table

• Truncate tables

DDL

How to Create Tables

Format:

CREATE TABLE table_name (
	column_1_name  data_type, 
	column_2_name  data_type,
	column_3_name  data_type,
	PRIMARY KEY(primary_key_name)
);