|
The SELECT INTO Statement: It is unique to Access SQL, Used to create a new table from the rows in another table or query.
|
|
Syntax: SELECT column1 [,column2[,..]] INTO new-table
|
|
Example: SELECT OrderId, OderDate INTO tblJonesOrders FROM tblOrder WHERE CustomerId=9;
|
Access SQL supports 4 DDL (Data Definition Language) statements:
-
CREATE TABLE - Creates a new table schema
-
ALTER TABLE - Modifies an existing table schema
-
CREATE INDEX - Creates a new index
-
DROP - Deletes a table schema or an index
|
|
Data Access Objects (DAO) is another method, like DDL, to programmatically create and manipulate table schemas in Access.
|
