MySQL Forums
Forum List  »  Federated Storage Engine

Is it safe to drop a federated table
Posted by: Jared Cope
Date: April 19, 2006 03:04AM

Hi,

This is probably a simple straightforward answer, but wanted to check before I do something stupid.

I have created my federated table (fed1) on server A that points to another table (table1) on server B.

I realize now that I want to drop this fed1 table in order to re-create it with a new connection string.

Is it safe to simply do this statement on server A:

drop table fed1;

and be assured that table1 on server B will survive? That is, the drop statement is also not applied to serverB ?

Cheers, Jared.

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it safe to drop a federated table
9406
April 19, 2006 03:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.