On Fri, Sep 02, 2005 at 05:28:11PM -0400, Hrishikesh Deshmukh wrote: > We are designing a database, the database has three major components (each > component with 4-8 tables) > two components are ready, is it possible to 'overlay' the third one later? > or > Do i have to drop all the components (along with data!!!) and then add the > third component and then build the entire DB? > What i am saying is some tables are existing, could i later add a bunch of > tables at a later date without dropping the entire database? What exactly do you mean by "overlay"? As far as the database is concerned, you can create tables any time you want: today, tomorrow, or a year from now. Is there some specific case you're concerned about? If so then please elaborate. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster