User Manual

Contentsviii
Modify Database File Size 104
Deallocate Database Files 107
Create and Alter Tables 109
Understand SQL Server Data Types 109
Create a Table 112
Alter a Table 115
Drop a Table 117
Chapter 4: Executing Basic Queries 119
Use SQL Server Schemas 120
Understand Schemas 120
Create Schemas 123
Associate Objects with Schemas 125
Select Data from a Database 128
Use Basic Select Syntax 128
Group and Aggregate Data 133
Join Data Tables 136
Use Subqueries, Table Variables, Temporary Tables,
and Derived Tables 138
Modify Data 144
Insert Data 144
Delete Data 146
Update Data 146
Use the SQL Server System Catalog 148
Use System Views 148
Use System Stored Procedures 151
Use Database Console Commands 153
Part II: Data Integrity and Security 155
Chapter 5: Managing Data Integrity 157
Implement Entity Integrity 158
Implement Primary Keys 159
Implement Unique Constraints 163
Implement Domain Integrity 167
Implement Default Constraints 167
Implement Check Constraints 170
Implement Referential Integrity 174
Implement Foreign Keys 176
Implement Cascading References 179
Understand Procedural Integrity 182
Understand Stored Procedure Validation 183
Understand Trigger Validation 185
96602book.indb 8 7/23/09 4:04:16 PM