Microsoft SQL Server Retrieve Database Options


Example

The following query returns the database options and metadata:

select * from sys.databases WHERE name = 'MyDatabaseName';