How to view the table create SQL statement

M

Man Utd

I have created a table in design view.
How do I view the SQL of the table create statement ?
 
A

Albert D.Kallal

Man Utd said:
I have created a table in design view.
How do I view the SQL of the table create statement ?
Click to expand...
The above information is not created, nor saved in ms-access.

you can certainly use DDL commands to create your tables, and save a copy of
those sql ddl statements. However, if you use the GUI, then that info is not
generated, so it is not available. There are some 3rd party tools that will
generate sql scripts for you. Also, Visio (enterprise edition) I believe
also
can generate the ddl scripts from a ms-access table.

Anyway, here is ref for some ddl examples:

How to use common Data Definition Language (DDL) SQL statements for the Jet
database engine
http://support.microsoft.com/default.aspx?scid=kb;en-us;180841
 
M

Man Utd

Because I want to create an Access table in my program using SQL statement,
one of the fields is BLOB and the othe is auto-increment.
And there are also an integer and float number fields I am also going to
create:
What syntax should I use ?

CREATE TABLE TestTable
(ID <-- auto-increment,
LargeData <-- BLOB
Age <-- INTEGER
Balance <- FLOAT
)

Can you create the SQL for me ?
 
Top