Re: [GENERAL] Schema overlay question

2005-09-02 Thread Michael Fuhr
On Fri, Sep 02, 2005 at 07:16:04PM -0400, Hrishikesh Deshmukh wrote: > What i meant was when the third component of tables are ready and i can > create tables any time what happens to relationships when i am building the > third component tables? How smooth the process will be? What relationshi

Re: [GENERAL] Schema overlay question

2005-09-02 Thread Hrishikesh Deshmukh
HI All, What i meant was when the third component of tables are ready and i can create tables any time what happens to relationships when i am building the third component tables? How smooth the process will be? Regards, Hrishi On 9/2/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Fri, Sep 02,

Re: [GENERAL] Schema overlay question

2005-09-02 Thread Michael Fuhr
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 (

Re: [GENERAL] Schema overlay question

2005-09-02 Thread Douglas McNaught
Hrishikesh Deshmukh <[EMAIL PROTECTED]> writes: > 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? Sure, you can do CREATE TABLE at any time. -Doug ---(end of broadcast)-

[GENERAL] Schema overlay question

2005-09-02 Thread Hrishikesh Deshmukh
Hi All, A simple question to the list. 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 thir