The CREATE TABLE order information TABLE
(order no. Char (10), NOT NULL PRIMARY KEY,
Customer number char (8) NOT NULL,
Marki number char (1) NOT NULL,
Order time datetime default (getdate ()) NOT NULL,
Foreign key (customer number)
The references of customer information table (customer number),
Foreign key (marki number)
References distribution member information table (marki number)
)

CodePudding user response:

Correct you, you are creating a table, not create a view,
Create a table, haven't found the same table name exists, cannot create normal