[dba-SQLServer] Generate DDL statements from an Access db?

Arthur Fuller fuller.artful at gmail.com
Sun Feb 3 13:42:46 CST 2008


That's DML Susan, not DDL. (Manipulation vs. Definition.)
A.

On Sun, Feb 3, 2008 at 2:23 PM, Susan Harkins <ssharkins at gmail.com> wrote:

>
>
> > Does anyone know of a program that will generate CREATE TABLE statements
> > from an Access database? My import and export wizard seems to be broken
> > and
> > the disks are off-site. I would just do it by hand but several of the
> > tables
> > have lots of columns.
>
> =========Would the SQL View window be of any help -- I mean, you could use
> the design window to drag and drop, then cut and paste from the SQL View
> window and insert CREATE TABLE manually -- might beat a blank.
>
> Susan H.
>
>



More information about the dba-SQLServer mailing list