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:
             Figure 9.1: Choose SQL view for the query


Share This Book