清單_失效日期

SELECT name AS LoginName,
   DATEADD(DAY, CAST(LOGINPROPERTY(name, 'DaysUntilExpiration') AS int), GETDATE()) AS ExpirationDate,
   create_date
   FROM sys.server_principals
   WHERE type = 'S'

清單_索引

select o.name
 , i.*
from sys.objects o
inner join sys.indexes i on i.object_id = o.object_id
where o.is_ms_shipped = 0
  and i.object_id > 100
  and i.index_id > 0
order by o.name
   , i.index_id;

清單_使用者

SELECT * FROM Sys.login_token
where type='SQL LOGIN'

清單_所有資料庫

--所有資料庫清單
select suser_sname(owner_sid) as 'Owner', state_desc, *
from sys.databases

--資料庫角色
SELECT * FROM sys.database_principals

清單_資料表

SELECT * FROM msdb.information_schema.tables

WHERE TABLE_TYPE='BASE TABLE'
-- WHERE TABLE_TYPE != 'VIEW

==================

SELECT sobjects.name
FROM sysobjects sobjects
WHERE sobjects.xtype = 'U'

Here is a list of other object types you can search for as well:

• AF: Aggregate function (CLR)
• C: CHECK constraint
• D: Default or DEFAULT constraint
• F: FOREIGN KEY constraint
• L: Log
• FN: Scalar function
• FS: Assembly (CLR) scalar-function
• FT: Assembly (CLR) table-valued function
• IF: In-lined table-function
• IT: Internal table
• P: Stored procedure
• PC: Assembly (CLR) stored-procedure
• PK: PRIMARY KEY constraint (type is K)
• RF: Replication filter stored procedure
• S: System table
• SN: Synonym
• SQ: Service queue
• TA: Assembly (CLR) DML trigger
• TF: Table function
• TR: SQL DML Trigger
• TT: Table type
• U: User table
• UQ: UNIQUE constraint (type is K)
• V: View
• X: Extended stored procedure

找trigger的語法如下:

Oracle

Oracle

Azure

Azure

雜項

雜項

SQL Server 高可用性

SQL Server 高可用性

SSIS

SSIS

Hyper-V

Hyper-V