search

himselfv / jet-tool

MS Jet database schema export/SQL execution tool
21 stars 3 forks source link

DROP statements missing for foreign keys #6

Closed himselfv closed 7 years ago

himselfv commented 7 years ago

Original report by Anonymous.

jet dump -f "MyDatabase.mdb" generates SQL output with DROP statements except for the relations or foreign keys.

I think it needs statements like: ALTER TABLE [mytable] DROP CONSTRAINT [myconstraint]

The ability to drop all relations and re-create all relations is a very useful feature (it lets me replace one or more tables easily). This tool would be even better for this task if it could generate DROP statements without me having to edit out the ...ADD CONSTRAINT... statements (an option such as --droponly or --no-create).

Thanks, Paul.W -at- IndustrialControl.co.nz

himselfv commented 7 years ago

Original comment by himselfv (Bitbucket: 557058:736ea475-fec1-499e-93e9-568104650027, GitHub: himselfv).

Implemented both suggestions in 0.5. Let me know if anything is wrong.

E.g.

jet dump -f database.mdb --drop --no-create --relations will dump only DROP commands for relations.