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)
SQLserver (PRIMARY KEY Constraint)
4/
5
Oleh
Unknown