• SQL Server
• ::
• Table Structure
• ::
• ALTER TABLE NOCHECK CONSTRAINT

subject:ALTER TABLE NOCHECK CONSTRAINT
syntax:ALTER TABLE tbl_name
NOCHECK CONSTRAINT { ALL | constraint_name }
content:ใช้กำหนด หยุด การใช้งาน constraint ที่กำหนด
example:CREATE TABLE tbl_orders
(
	id int IDENTITY NOT NULL,
	price money NOT NULL,
	discount int NOT NULL,

	CONSTRAINT tbl_orders_pk PRIMARY KEY (id),
	CONSTRAINT chk_amount CHECK ( price > 0 )
)
ALTER TABLE tbl_orders
NOCHECK CONSTRAINT chk_amount