萊恩大叔

紀錄一下 USE DatabaseName Go SELECT t.NAME AS TableName, --s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 /1024 AS TotalSpaceMB, SUM(a.used_pages) * 8 /1024 AS UsedSpaceMB, (SUM(a.total_pages) - SUM(a.used_pages)) * 8 /1024 AS UnusedSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE t.NAME NOT LIKE 'dt%' AND t.is_ms_shipped = 0 AND i.OBJECT_ID > 255 GROUP BY t.Name, s.Name, p.Rows ORDER BY t.Name 參考來源： http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database

--postgresql get sequence_name list select sequence_name from information_schema.sequences where sequence_schema='public' 參考來源： https://diego.org/2008/10/10/postgresql-sequences/ --MSSQL(MSSQP2012或以上版本) get sequence_name list SELECT name FROM sys.sequences 參考來源： http://raresql.com/2012/10/24/sql-server-2012-list-of-all-sequences-available-in-the-database/

[PostgreSQL] SELECT column_name , data_type from information_schema.columns where table_name = ' test_table '; 紅色字部分為資料表名稱 搜尋結果 UI設定畫面 [MSSQL] SELECT COLUMN_NAME,DATA_TYPE,COLUMN_DEFAULT from information_schema.columns where table_name = ' table_Name ';

目前連線數 USE master SELECT cntr_value AS User_Connections FROM sys.sysperfinfo AS sp WHERE sp.object_name='SQLServer:General Statistics' AND sp.counter_name='User Connections' 連線明細 USE master SELECT c.session_id, c.connect_time, s.login_time, c.client_net_address, s.login_name, s.status FROM sys.dm_exec_connections c left join sys.dm_exec_sessions s on c.session_id = s.session_id 參考: http://mark528.pixnet.net/blog/post/62330671-%E5%A6%82%E4%BD%95%E6%9F%A5%E8%A9%A2sql-server%E7%9B%AE%E5%89%8D%E9%80%A3%E7%B7%9A%E6%95%B8