captainc Messages: 278 Registered: December 2006 Location: New Jersey, USA
Experienced Member
Thank you for the explanation; very helpful.
Quote:
All_Tables will "dump" SQL scripts from .sch file and stores them into database.
If this is going to execute the scripts anyway, what is the use for checking for changes to update immediately after? Will All_Tables() only execute the "create tables" sql from the "S_*.sql" file, whereas Upgrade() will execute the "U_*.sql" file?
Also, is there an equivalent to the All_Tables() function that will only compare the current scripts with the potential new ones and not execute the create statements (even though the create statements simply fail when the table already exists...)?