tags:

views:

31

answers:

1
Q: 

alter database name

hi everyone will u please tell me how to alter database name from test to test1. thanks in advance

A: 

If its a SQL Server 2000 or 2005 database use the following T-SQL: command to make the database name change.

EXEC sp_renamedb 'oldName', 'newName'

The new command that should be used for SQL Serer 2005 and beyond is:

ALTER DATABASE oldName MODIFY NAME = newName

For Oracle database see here

Zaps  2010-05-20 07:48:07

related questions

mysqli problem - prepared statements
mysqli binding fields in a prepared statement
How can I get every n rows in MySQL?
mysqli bind variables
Converting mysql to mysqli - how to get superglobal connection object?
php giving a blank page, no errors
converting from mysql to mysqli - outputting variables
The counterpart of mysqli::real_escape_string?
Limit a MySQL query to an even number of results (using PHP and mysqli)
Getting a PHP DateTime object into a string representation of a MYSQL date
Ensuring MySQL connection works in PHP function
mysqli prepared statements and REPLACE INTO
using nulls in a mysqli prepared statement
Do MySQL prepared queries provide a performance benefit for once-per-session queries?
mysqli->error: Is it for the last query only, or for the last error from the query group?
Is there a way to see a prepared query as it will be executed on the database?
Is there a way to bind an array to mysqli prepare
Empty string in not-null column in MySQL?
Which is fastest in PHP- MySQL or MySQLi?
Possible to use multiple/nested MySQLi statements?
mysqli_statement::num_rows() returns the wrong value
PHP + MySql + Stored Procedures, how do I get access an "out" value?
Using MySQLi - which is better for closing queries
mysqli or PDO - what are the pros and cons?
PHP + MYSQLI: Variable parameter/result binding with prepared statements.