Untitled
unknown
plain_text
a year ago
598 B
1
Indexable
ALTER TABLE KHACHHANG ALTER COLUMN [Customer ID] char(10) not null ALTER TABLE KHACHHANG ADD CONSTRAINT PK_KHACHHANG PRIMARY KEY ([Customer ID]) SELECT COUNT(*) FROM Orders SELECT COUNT(DISTINCT [ORDER ID]) FROM Orders SELECT COUNT(DISTINCT [ROW ID]) FROM Orders ALTER TABLE ORDERS ALTER COLUMN [CUSTOMER ID] CHAR(10) NOT NULL ALTER TABLE ORDERS ALTER COLUMN [ROW ID] INT NOT NULL ALTER TABLE ORDERS ADD CONSTRAINT PK_ORDER PRIMARY KEY ([ROW ID]) ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_KHACHHANG FOREIGN KEY ([CUSTOMER ID]) REFERENCES KHACHHANG([CUSTOMER ID])
Editor is loading...
Leave a Comment