Difference between revisions of "ALTER DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 10: Line 10:
 
== Related ==
 
== Related ==
 
* [[Parameter groups]]
 
* [[Parameter groups]]
 +
* [[mv]]
  
 
== See also ==
 
== See also ==

Revision as of 11:36, 12 October 2022

In SQL Server, this statement modifies a database, or the files and filegroups associated with the database.

  • ALTER DATABASE your_db OWNER TO your_user;
ALTER DATABASE database_name CHARACTER SET character_set_name COLLATE collation;
ALTER DATABASE old_database_name RENAME TO new_database_name;


Related

See also

Advertising: