查詢Database中所有trigger、匯出資料庫特定物件

Posted on by febr

[sql]
–查詢Database中所有trigger
SELECT o.name,
c.text
FROM sys.objects AS o
INNER JOIN sys.syscomments AS c
ON o.object_id = c.id
WHERE o.type = ‘TR’
[/sql]

將stored procedure做匯出:
1. 資料庫(右鍵)->工作->產生指令碼
2.選取欲匯出的物件(table, stored procedure或view)