You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
342 B
19 lines
342 B
3 years ago
|
USE Study
|
||
|
|
GO
|
||
|
|
|
||
|
|
CREATE TABLE orders5(
|
||
|
|
oseq INT IDENTITY(1, 1),
|
||
|
|
quantity VARCHAR(20) NULL,
|
||
|
|
indate DATETIME NULL,
|
||
|
|
id VARCHAR(20),
|
||
|
|
pcode VARCHAR(20)
|
||
|
|
)
|
||
|
|
|
||
|
|
ALTER TABLE orders5
|
||
|
|
ADD CONSTRAINT PK_oseq5 PRIMARY KEY (oseq)
|
||
|
|
|
||
|
|
ALTER TABLE orders5
|
||
|
|
ADD CONSTRAINT FK_id5 FOREIGN KEY (id) REFERENCES customer(id)
|
||
|
|
|
||
|
|
ALTER TABLE orders5
|
||
|
|
DROP CONSTRAINT FK_id5
|