O'Reilly logo

Windows® CE 3.0 Application Programming by Marshall Brain, Nick Grattan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required