Editing and Creating Queries in SQL View
There are three types of queries that you must create in SQL view: data definition queries, pass-through queries, and union queries.
In a desktop application, Access supports a limited subset of the ANSI-standard SQL language for data definition. You can execute basic CREATE TABLE and ALTER TABLE commands in a data definition query, but you cannot define any Access-specific properties such as the Input Mask or Validation Rule property. The syntax is so limited that we don’t cover it in Article 2.
When you’re using linked tables to a server database system, such as Microsoft SQL Server or Oracle, you might need ...