What is alter database?
ALTER DATABASE enables you to change the overall characteristics of a database. These characteristics are stored in the data dictionary. This statement requires the ALTER privilege on the database. ALTER SCHEMA is a synonym for ALTER DATABASE . In that case, an error occurs if there is no default database.
What is the job of alter database command?
In SQL 2012 the alter command modifies a database or the file and filegroups which are associated with the database. You can add or remove files from as database, changes the attributes of a database or its files and filegroups, changes the database collation, and sets database options.
When to use alter database scoped configuration in SQL Server?
ALTER DATABASE SCOPED CONFIGURATION (Transact-SQL) This statement enables several database configuration settings at the individual database level. This statement is available in Azure SQL Database and in SQL Server beginning with SQL Server 2016 (13.x).
What are some applications of database scoped credential?
Here are some applications of database scoped credentials: SQL Server uses a database scoped credential to access non-public Azure blob storage or Kerberos-secured Hadoop clusters with PolyBase. To learn more, see CREATE EXTERNAL DATA SOURCE (Transact-SQL).
How are DDL triggers scoped in SQL Server?
Multiple triggers to be created for each DDL event. Unlike DML triggers, DDL triggers are not scoped to schemas. Therefore, functions such as OBJECT_ID, OBJECT_NAME, OBJECTPROPERTY, and OBJECTPROPERTYEX cannot be used for querying metadata about DDL triggers.
When to grant permissions at the server scope?
Specifies a SQL Server login mapped to a Windows login. Specifies a SQL Server login mapped to a Windows group. Specifies a SQL Server login mapped to a certificate. Specifies a SQL Server login mapped to an asymmetric key. Specifies a user-defined server role. Permissions at the server scope can be granted only when the current database is master.