user2766423 user2766423 - 2 months ago 6
SQL Question

How can I view the sql access generated to create an existing table?

If a table was created using Access, how can I look up the SQL Access generated to create that table?

Answer

You cannon see the original SQL used to create a table, but you can see the SQL that Access generates -or could be used- to create a table.

The SQL is basically a SELECT...INTO

Create a new query, then convert the query to a 'Make Table' query, Then display the SQL with a right-click context menu.

enter image description here

In this example the SQL generated is:

   SELECT Table1.ID INTO tbl_foo
   FROM Table1;