|
查看: 1044|回复: 0
|
MS SQL 2000 create DOMAIN有问题。。。。
[复制链接]
|
|
|
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。。。。 |
|
|
|
|
|
|
|
|
| |
本周最热论坛帖子
|