Delete Trigger example in Sybase - Hallo there Sarah Server reader, this time we will talk about Delete Trigger example in Sybase, We have prepared this article for you, hope you enjoy this Guide, Happy reading.

Title : Delete Trigger example in Sybase
link : Delete Trigger example in Sybase

Delete Trigger example in Sybase

1> sp_helptext empage_delete_restrict
2>
# Lines of Text
---------------
1
(1 row affected)
text
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
create trigger empage_delete_restrict on empage
for delete
as
begin
print 'Delete of records not allowed in this table'
rollback transaction
end

(1 row affected)
(return status = 0)
1> select * from empage
2>
empid empage
----------- -----------
654 23
76 45
6 43
100 29
65 60
(5 rows affected)
1> delete from empage where empid = 100
2>
Delete of records not allowed in this table
1> select * from empage
2>
empid empage
----------- -----------
654 23
76 45
6 43
100 29
65 60
(5 rows affected)
1>

There is Delete Trigger example in Sybase

Thus article Delete Trigger example in Sybase this time, hope can give benefits to all of you. well, see you in other post.

You are reading Delete Trigger example in Sybase with link https://saraserver.blogspot.com/2010/01/delete-trigger-example-in-sybase.html