Page 5 - SQL
P. 5
DECIMAL and NUMERIC 36
FLOAT and REAL 36
Integers 36
MONEY and SMALLMONEY 36
BINARY and VARBINARY 37
CHAR and VARCHAR 37
NCHAR and NVARCHAR 37
UNIQUEIDENTIFIER 38
Chapter 14: DELETE 39
Introduction 39
Syntax 39
Examples 39
DELETE certain rows with WHERE 39
DELETE all rows 39
TRUNCATE clause 39
DELETE certain rows based upon comparisons with other tables 39
Chapter 15: DROP or DELETE Database 41
Syntax 41
Remarks 41
Examples 41
DROP Database 41
Chapter 16: DROP Table 42
Remarks 42
Examples 42
Simple drop 42
Check for existence before dropping 42
Chapter 17: Example Databases and Tables 43
Examples 43
Auto Shop Database 43
Relationships between tables 43
Departments 43
Employees 44
