The Pocket SQL Data Definition Language

Abstract

The sql data definition language (DDL) specifies how various database objects are created, modified, and deleted. Normally these objects include such things as tables, views, privileges, indexes, triggers, and stored procedures. In Chapter 1, you learned that on the Pocket PC you’re limited to using a subset of the Structured Query Language. It should then come as no surprise that you’ll find yourself limited when it comes to the database objects you can work with. Those of you who are accustomed to using GUI tools, such as Microsoft Access or the SQL Server Enterprise Manager, to construct and modify databases are probably wondering why you even need to know the Pocket SQL DDL. The answer is simple: There is no GUI tool available to build and modify Pocket Access databases on the Pocket PC. Pocket Access databases have to be built programmatically using Pocket SQL DDL, eMbedded Visual Basic, and ADOCE. While it may seem like you’re having to do things the hard way, you’ll gain the skills you need to build your own Access-like GUI tool later on in this book.