04/09/24

alter table, primary key, drop index, create index unique

 ALTER TABLE dataIABEE

ALTER COLUMN iabeeID [uniqueidentifier] NOT NULL;


ALTER TABLE dataIABEE

ADD PRIMARY KEY (iabeeID);


drop INDEX dataIABEE.idx_dataIABEE


CREATE UNIQUE INDEX idx_dataIABEE

ON dataIABEE (kode_kul,kelas,semester,fakjur);


Postingan Lebih Baru Postingan Lama