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.
Window Functions - ROW_NUMBER()
create table with constraunt
Hotel
Ejercicios de SQL (I)9
dbray
SQL
Alquileres
20181CSE0534
Solution 3
Cristina
Please log in to post a comment.