SQLserver (CHECK Constraint)

Download :  Check Constraint

 

• Membuat CHECK Constraint melalui CREATE TABLE pada column yg bersangkutan :

CREATE TABLE MsBarang

(

          Kd_Barang NCHAR(5),

          Nm_Barang NVARCHAR(30),

          Harga MONEY,

          Stock INT CHECK (Stock > 0)

)

• CHECK Constraint pada akhir definisi table :

CREATE TABLE MsBarang

(

          Kd_Barang NCHAR(5),

          Nm_Barang NVARCHAR(30),

          Harga MONEY,

          Stock INT,

          CHECK (Kd_Barang LIKE 'BEG-__')

)

• CHECK Constraint melalui perintah ALTER TABLE :

ALTER TABLE MsBarang ADD CONSTRAINT CH_Constraint CHECK (Stock < 0)

• Menggunakan RULE object :

CREATE RULE RULE_Stock AS @st > 0
GO
sp_bindrule 'RULE_Stock' , 'MsBarang.Stock'

• Untuk melepaskan RULE :

sp_unbindrule 'MsBarang.Stock'
GO
DROP RULE RULE_Stock

Share : SQLserver (CHECK Constraint)

Related Posts

SQLserver (CHECK Constraint)

4/ 5

Oleh Unknown