|
-
Dec 23rd, 2014, 08:52 PM
#1
VB6 create DDL-Schema-instructions from JET-MDBs (to apply to a new created *.mdb)
As the title says - the Demo will show, how to create DDL-SQL-instructions from a given *.mdb-File,
using two small Classes (cJETDDL and cJETDDLTable).
The DDL is created for existing:
- Table-Definitions
- Index-Definitions
- Foreign-Key relations
- Views and Queries
In the example I'm using (also coming included in the Demo-Zip) the "official JET-Demo-DB" (NWind.mdb).
There's a little GUI around the functionality of the two above mentioned Classes, which shows
the Text-Output they did produce for the different kinds of DDL-Statements.
Here's a ScreenShot:

And here is the Demo-zip.
I think the whole thing is educational for those who want to learn DDL, to define - or alter
their DB-Schemas "per Code".
Olaf
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|