SQLÓï¾ä²éѯÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÔõôÓÃSQLÓï¾ä²éѯij¸öÊý¾Ý¿âµÄÐÅÏ¢´æ´¢ÓÚÄļ¸¸öϵͳ±í£¿

---

SQL code:
select * from sys.database

---

¡£¡£¡£¡£¡£ÕâҲ̫¶àÁË°É

---

SQL code:
select * from sys.databases

---

SQL code:
select * from sysdatabase

---

SQL code:
use master
go
select * from sysdatabases

---

ºÃµÄ£¬Ð»Ð»¸÷λ°ïÖú£¬ÎÒÊÔÊÔ¡£

---

SQL code:
select * from sysdatabases

---

sys.databases 

sys.database_files 

 
sys.dm_db_file_space_usage (Transact-SQL)£¨½ö tempdb£©
  
  
 
sys.dm_db_session_space_usage£¨½ö tempdb£©
  
  
 
sys.dm_db_task_space_usage£¨½ö tempdb£©
 

---

Èç¹ûÎÒÒª²éÕÒtempdbÊý¾Ý¿âÔÚsql 2005ÖÐËùÉæ¼°µ½µÄÊÓͼ²éѯÓï¾äÔõôдѽ£¿
ÄܸøÒ»¸ö±È½ÏÍêÕûµÄ´úÂëÂð£¿

---

ÒýÓÃ

Èç¹ûÎÒÒª²éÕ