Modifying and Updating Tables and Indexes

Chapter 6. Modifying and Updating Tables and Indexes

6.1	Introduction 180
6.2	Modifying Tables 180
	6.2.1 Adding New Columns 180
	6.2.2 Controlling the Position of Columns in a Table 182
	6.2.3 Changing a Column’s Length 184
	6.2.4 Changing a Column’s Format 189
	6.2.5 Changing a Column’s Label 189
	6.2.6 Renaming a Column 190
	6.2.7 Renaming a Table 192
6.3	Indexes 194
	6.3.1 Defining Indexes 194
	6.3.2 Creating a Simple Index 195
	6.3.3 Creating a Composite Index 196
	6.3.4 Preventing Duplicate Values in an Index 197
	6.3.5 Modifying Columns Containing Indexes 197
	6.3.6 Deleting (Dropping) Indexes 198
6.4	Updating Data in a Table 199
6.5	Summary 200

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.