[Feature Request] Add 'IF EXISTS' as an option to DROP TABLE
The current versions of SQL RDBMSs all support the DROP TABLE IF EXISTS syntax.
In most systems, if you try to drop a table that doesn't already exist, it will generate an error. Right now, when we select the 'include DROP TABLE' option, Generatedata creates a DROP TABLE statement without the 'IF EXISTS' option - which generates an error most current, empty databases.
It would be nice if Generatedata added the 'IF EXISTS' clause by default. If we are concerned about people using legacy systems that might not understand the optional clause, then we could add a checkbox that would allow people to 'omit IF EXISTS' (but that would not be the default).
Thank you for running and maintaining this amazing and super useful project!
Great idea, thanks @luxlogica!