Page 2 - SQL
P. 2
Table of Contents
About 1
Chapter 1: Getting started with SQL 2
Remarks 2
Versions 2
Examples 2
Overview 2
Chapter 2: ALTER TABLE 4
Introduction 4
Syntax 4
Examples 4
Add Column(s) 4
Drop Column 4
Drop Constraint 4
Add Constraint 4
Alter Column 5
Add Primary Key 5
Chapter 3: AND & OR Operators 6
Syntax 6
Examples 6
AND OR Example 6
Chapter 4: Cascading Delete 7
Examples 7
ON DELETE CASCADE 7
Chapter 5: CASE 9
Introduction 9
Syntax 9
Remarks 9
Examples 9
Searched CASE in SELECT (Matches a boolean expression) 9
Use CASE to COUNT the number of rows in a column match a condition. 10
