• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

6. Access Structured Query Language (SQL... > 6.6. The DDL Component of Access SQL

The DDL Component of Access SQL

We begin by looking at the data definition commands in Access SQL. These commands do not have a counterpart in Query Design View (although, of course, you can perform these functions through the Access graphical environment). Access SQL supports these four DDL commands:

  • CREATE TABLE

  • ALTER TABLE

  • DROP TABLE

  • CREATE INDEX

I should mention now that there is some duplication of features in the DDL commands. For instance, you can add an index to a table using either the ALTER TABLE command or the CREATE INDEX command.

The CREATE TABLE Statement

The CREATE TABLE command has the following syntax:

CREATE TABLETableName 
 (ColumnDefinition,...
 [,Multi-ColumnConstraint,...] );

PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint