9. DATA DEFINITION LANGUAGE (DDL)

9.1: Running DDL in MS Access

Most database systems provide a way for you to run data definition language commands. When such facility exists, it can be relatively easy to create and re-create databases from a file of DDL commands. One way to run DDL commands in MS Access is through a query that is in SQL View. To run a DDL command we follow these two steps:

      • Open a database and choose to create a query, but do not add any tables to the query
      • Then, choose SQL View and you will be able to type a DDL command or paste one in:
image
             Figure 9.1: Choose SQL view for the query

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Relational Databases and Microsoft Access 365 Copyright © by Ron McFadyn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book