Re: [GENERAL] More newbie question: Restructuring a table

2000-03-01 Thread Karel Zak - Zakkr
On Wed, 1 Mar 2000, Timothy Grant wrote: > Hi again, > > Is there a quick and dirty way that I am missing for creating a new > database with a slightly different schema than the old db? > > For example, I have a table with a DATETIME field that I really need to > change to a DATE field. > > I

[GENERAL] More newbie question: Restructuring a table

2000-03-01 Thread Timothy Grant
Hi again, Is there a quick and dirty way that I am missing for creating a new database with a slightly different schema than the old db? For example, I have a table with a DATETIME field that I really need to change to a DATE field. I can create a new table with that field defined as a DATE, bu