ALTER DATABASE

From wikieduonline
Revision as of 15:14, 18 November 2022 by Ant (talk | contribs) (→‎Related)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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[edit]

ERROR: must be owner of database
DROP DATABASE

See also[edit]

Advertising: