Not storing the DDL was: Changing an SQL table (Best practices)

<snip>
Actually, I end up not storing it at all.

I use iNav to generate the current source, make my change, add the drop
table line and recreate it.
</snip>

Charles I really hate to say this, because it gives the Luddites and 
naysayers ammunition to stick with DDS.  However, I have had more than one 
table that had constraints that I can no longer do a DSPFD and see the 
creating SQL.  The DSPFD errors out with a MCH* error.
But the cool thing is that your iNav trick still works.

Rob Berendt