Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
TRIGGERS
SELECT table_name = OBJECT_NAME(parent_object_id) , trigger_name = name , trigger_owner = USER_NAME(schema_id) , OBJECTPROPERTY(object_id, 'ExecIsUpdateTrigger') AS isupdate , OBJECTPROPERTY(object_id, 'ExecIsDeleteTrigger') AS isdelete , OBJECTPROPERTY(object_id, 'ExecIsInsertTrigger') AS isinsert , OBJECTPROPERTY(object_id, 'ExecIsAfterTrigger') AS isafter , OBJECTPROPERTY(object_id, 'ExecIsInsteadOfTrigger') AS isinsteadof , CASE OBJECTPROPERTY(object_id, 'ExecIsTriggerDisabled') WHEN 1 THEN 'Disabled' ELSE 'Enabled' END AS status FROM sys.objects WHERE type = 'TR' ORDER BY OBJECT_NAME(parent_object_id)
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Rno 37 boat
QLDT_TUAN 7
Pro 2
TEST 2
MS SQL Joins
securing critical sections with manual locks in sql server
Extracting Id No
a
emp 4
Yan_1st_wall
Please log in to post a comment.