Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Change database name

Status
Not open for further replies.
craig322

craig322

MIS
Apr 19, 2001
108
US
Does anyone know of a way to change the database name? I have exported my production database into a test instance and want to change the name to eliminate any confusion. For example, if I now access the database as my_production@my_test_server. I would like to change it so I access it as my_development@my_test_server.

TIA
 
Sort by date Sort by votes
I figured out my own question. Never thought it would be an SQL command.

RENAME DATABASE my_production TO my_development.

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
200
jamescpp
jamescpp
unmaxpine
  • Locked
  • Question
Change logging of a database
Replies
2
Views
165
unmaxpine
unmaxpine
albatross68
  • Locked
  • Question
Calling functions by name (dynamically)
Replies
0
Views
61
albatross68
albatross68
greggory
  • Locked
  • Question
How to change the directory for open form 1
Replies
1
Views
70
olded
olded
carstos2000
  • Locked
  • Question
How to enable database logging?
Replies
2
Views
121
mjldba
mjldba

Part and Inventory Search

Sponsor

Back
Top