Re: Views dropped automatically when altering tables?

2012-02-08 Thread John English
On 07/02/2012 18:38, Dag H. Wanvik wrote: At least for the DROP COLUMN feature, the syntax looks like this: DROP [ COLUMN ] column-name [ CASCADE | RESTRICT ] OK, thanks. I'm over my surprise now and have read and understood, so I won't be taken unawares again in future!

About db file sizing

2012-02-08 Thread Carlos de Luna Saenz
I really don't know if this is a good couple questions or not... We are developing an embedded DB app that has a 1.74GB of files for the database I wonder if there is something like a shrink or compact command that will reduce the amount of space for the app DB. Is there a way to make it