How to detect a SQL Server database’s read-only status using T-SQL?

The information is stored in sys.databases.

SELECT name, is_read_only 
FROM sys.databases 
WHERE name="MyDBNAme"
GO

--returns 1 in is_read_only when database is set to read-only mode.