CREATE DOMAIN ID_DOM AS VARCHAR(6)
CREATE DOMAIN NAME_DOM AS VARCHAR(15)
CREATE DOMAIN GEN_DOM AS CHAR(1)CHECK(VALUE IN (‘M’,’m’,’F’,’f’))
CREATE table book
(
Booking_no ID_DOM CONSTRAINT const_book_id NOT NULL,
NRIC varchar(12) CONSTRAINT const_ins_id NOT NULL,
Flight_no ID_DOM CONSTRAINT const_flight_no NOT NULL,
check_in char(1) CONSTRAINT const_check_in NOT NULL,
PRIMARY KEY (Booking_no)
)
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'DOMAIN'.
有谁有办法???
帮帮我下。。。
在INTERNET也找不到SOLUTION。。。。 |