SQL Server DATABASE PROPERTYEX
SQL Server DATABASE PROPERTYEX is a SQL function in the SQL Server Specific category. SQL Server: returns database-level property information like collation, recovery model, version. The syntax is SELECT DATABASEPROPERTYEX(db_name, property);. It accepts db_name, property. It returns database property. A typical example: SELECT DATABASEPROPERTYEX('MyDB', 'Collation') AS collation, DATABASEPROPERTYEX('MyDB', 'Recovery') AS recovery_model, DATABASEPROPERTYEX('MyDB', 'IsAutoShrink') AS auto_shrink, DATABASEPROPERTYEX('MyDB', 'IsPublished') AS is_published, DATABASEPROPERTYEX('MyDB', 'Version') AS db_version; A close relative is OUTPUT Clause, which sQL Server: returns values from DML statements (like PostgreSQL RETURNING). A close relative is STUFF(), which sQL Server: deletes a specified length of characters from a string and inserts another string at the start position. A close relative is FOR XML PATH, which sQL Server: converts query results to XML format. Commonly used for string concatenation hack. More about this category: SQL Server-specific features — T-SQL, OUTPUT, TOP, PIVOT, STUFF, FOR XML. Related SQL Server Specific entries: OUTPUT Clause, STUFF(), FOR XML PATH, TRY...CATCH, @@IDENTITY / SCOPE_IDENTITY(), GETDATE() / SYSDATETIME(), STRING_SPLIT(), TOP ... WITH TIES.