SQLserver (PRIMARY KEY Constraint)

 
Download :  PRIMARY KEY Constraint

 

• Membuat PRIMARY KEY melalui CREATE TABLE pada column yg bersangkutan :

CREATE TABLE MsBarang

(

          Kd_Barang NCHAR(5) PRIMARY KEY,

          Nm_Barang NVARCHAR(30),

          Harga MONEY,

          Stock INT

)

• PRIMARY KEY pada akhir definisi table :

CREATE TABLE MsBarang

(

          Kd_Barang NCHAR(5),

          Nm_Barang NVARCHAR(30),

          Harga MONEY,

          Stock INT,

          PRIMARY KEY (Kd_Barang)

)

• PRIMARY KEY melalui perintah ALTER TABLE :

ALTER TABLE MsBarang ALTER COLUMN Kd_Barang CHAR(5) NOT NULL

ALTER TABLE MsBarang ADD CONSTRAINT PK_Constraint PRIMARY KEY (Kd_Barang)

Share : SQLserver (PRIMARY KEY Constraint)

Related Posts

SQLserver (PRIMARY KEY Constraint)

4/ 5

Oleh Unknown