Difference between revisions of "ALTER DATABASE"

From wikieduonline
Jump to navigation Jump to search
Line 13: Line 13:
 
== See also ==
 
== See also ==
 
* {{SQL}}
 
* {{SQL}}
* {{PostgreSQL}}
 
  
 
[[Category:SQL]]
 
[[Category:SQL]]

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: