drop table
__________________________________________________________________________ This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. Thank you. __________________________________________________________________________ __________________________________________________________________________ Hi , I have tabel x in one dbspace and the index of the table x in another dbspace. Now my question , If I drop the table x , will it automatically drop the inex for the table x existing in another dbspace ? Thanks, Vadi
In article <77o5sd$ecr$1@news.xmission.com>, Vadi Vadivelpillai <Vadi_Vadivelpillai@jonesday.com> writes > > > >Hi , > >I have tabel x in one dbspace and the index of the table x in another >dbspace. >Now my question , > If I drop the table x , will it automatically drop the inex for the table >x existing >in another dbspace ? > Yes. >Thanks, > >Vadi > > -- David Williams
Absolutely. Bob ------- In article <77o5sd$ecr$1@news.xmission.com>, "Vadi Vadivelpillai" <Vadi_Vadivelpillai@jonesday.com> wrote: > > > __________________________________________________________________________ > > This message is intended for the individual or entity named above. If > you are not the intended recipient, please do not read, copy, use or > disclose this communication to others; also please notify the sender by > replying to this message, and then delete it from your system. Thank you. > __________________________________________________________________________ > > __________________________________________________________________________ > > Hi , > > I have tabel x in one dbspace and the index of the table x in another > dbspace. > Now my question , > If I drop the table x , will it automatically drop the inex for the table > x existing > in another dbspace ? > > Thanks, > > Vadi > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own