SELECT 数据库详细资料

 

SELECT   database_id AS DataBaseId ,
	DB_NAME(database_id) AS DataBaseName ,
	Name AS LogicalName ,
	type_desc AS FileTypeDesc ,
	Physical_Name AS PhysicalName ,
	State_Desc AS StateDesc ,
	CASE WHEN max_size = 0 THEN N'不允许增长'
		 WHEN max_size = -1 THEN N'自动增长'
		 ELSE LTRIM(STR(max_size * 8.0 / 1024 / 1024, 14, 2))+ 'G' END AS MaxSize ,
	CASE WHEN is_percent_growth = 1
		 THEN RTRIM(CAST(Growth AS CHAR(10))) + '%'
		 ELSE RTRIM(CAST(Growth AS CHAR(10))) + 'M' END AS Growth ,
	Is_Read_Only AS IsReadOnly ,
	Is_Percent_Growth AS IsPercentGrowth ,
	CAST(size * 8.0 / 1024 / 1024 AS DECIMAL(8, 4)) AS [Size(GB)]
FROM sys.master_files