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

Question

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

Answer 1

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.

In this example the SQL generated is:

   SELECT Table1.ID INTO tbl_foo
   FROM Table1;

Sign up