By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

i want to rename the table schema

P: n/a
Hello:

Now i want to rename the table schema

for example:

there is one table ,whose name is A.TEST,the A is the schema name,
now i want to rename the A TO B.
I want to get the B.TEST table.

What i should do .
Pls help me.
Thanks with best regards.
Jones

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
As far as I know, you can't change the schema name. RENAME will change
the table name. There are two possibilities:

1. CREATE TABLE B.TEST LIKE A.TEST
INSERT INTO B.TEST SELECT * FROM A.TEST
DROP TABLE A.TEST

2. CREATE ALIAS B.TEST FOR A.TEST

The second makes it appear theat B.TEST is the table without changing
the underlying object.

Phil Sherman

ga******@yahoo.com.cn wrote:
Hello:

Now i want to rename the table schema

for example:

there is one table ,whose name is A.TEST,the A is the schema name,
now i want to rename the A TO B.
I want to get the B.TEST table.

What i should do .
Pls help me.
Thanks with best regards.
Jones

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.