Microsoft SQL Server 2005, Compact Edition

Chapter 5. Defining the Database Structure

IN THIS CHAPTER

• Creating a Table

• Updating a Table Definition

• Dropping a Table

• Creating Indexes

• Viewing and Modifying Index Properties

• Deleting an Index

• Using Templates

• Using Metadata

• Creating a Database Project Using Visual Studio

• Summary

Chapter 4, Managing the SQL Server 2005 Compact Edition Database, discussed management operations such as database creation, verification, repair, and compaction. These operations are generally done by DBAs. As a database designer and developer, you will most likely want to know the procedure and syntax for database object creation. In this chapter we will walk through the creation of SQL Server Compact Edition objects—tables and indexes. One major limitation of SQL CE 2.0 was ...