SQL
DROP, TRUNCATE and DELETE Compared
Three ways to remove data, with very different consequences. Learn what each one destroys, what can be rolled back and what resets identity counters.
#DDL
Defining and changing database objects.
3 notes tagged
SQL
ALTER TABLE: Adding, Modifying and Removing Columns
ALTER changes a table that already holds data. Add and drop columns, change types, set defaults and manage constraints without losing rows.
SQL
CREATE: Databases, Schemas and Tables
CREATE defines the objects data lives in. Learn CREATE DATABASE, CREATE SCHEMA and CREATE TABLE, with column definitions and inline constraints.