If a table was created using Access, how can I look up the SQL Access generated to create that table?
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;