• SQL Server
• ::
• Table Structure
• ::
• ALTER TABLE { ENABLE | DISABLE } TRIGGERS

subject:ALTER TABLE { ENABLE | DISABLE } TRIGGERS
syntax:ALTER TABLE table_name
[ ENABLE | DISABLE ] TRIGGERS { ALL | trigger_name }
content:ใช้สั่งให้มีการ enable หรือ disable triggers 
example:CREATE TABLE tbl_orders
(
	id int IDENTITY NOT NULL,
	price money NOT NULL
)
GO
CREATE TRIGGERS trg_orders
ON orders
FOR INSERT, UPDATE
AS
	PRINT "Occurs Modify Data In Orders Table."
GO
ALTER TABLE tbl_orders
DISABLE TRIGGERS trg_orders
GO