SQL of table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to see the SQL statement of a table that is created in Desgin
View of MS-Access 2003 ? If so, how ?
 
No. Access is not able to reverse-engineer the table into a series of DDL
statements that define the table, its fields, constraints, etc, and all the
properties of the table, fields, etc.

In fact, it is not even possible to set some of these properties
programmatically using a DDL query statement.
 
Thanks.

Allen Browne said:
No. Access is not able to reverse-engineer the table into a series of DDL
statements that define the table, its fields, constraints, etc, and all the
properties of the table, fields, etc.

In fact, it is not even possible to set some of these properties
programmatically using a DDL query statement.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Example Of VBA SQL Statement 0
Linked Table Cant Delete Record 2
How to remove ''Enter parameter value'' 1
Remove ''Enter Parameter Value'' 1
Design advice SQL or QueryDef 2
Drop a table before creation in SQL? 8
Access stripping decimal places in query 1
Create Table with SQL command 2

Back
Top