Windows® CE 3.0 Application Programming

SQL Data Definition Language (DDL)

The ADOXCE object model allows the objects in a database (such as tables and columns) to be added, modified, and deleted. You can also use SQL statements to do the same, which can often be more convenient and quicker. These SQL statements are called "Data Definition Language," or DDL, statements. SQL statements that manipulate data are called "Data Manipulate Language," or DML, statements. The following DDL statements are supported:

• CREATE DATABASE

• CREATE TABLE

• CREATE INDEX

• ALTER TABLE

• DROP INDEX

• DROP TABLE

• DROP DATABASE

Using CREATE TABLE

The CREATE TABLE statement allows a table to be created by giving a name for the new table and the list of columns (fields) and their data types. The allowable data types for Microsoft ...