在SQL Server 2008中创建SQL关系！ [英] Creating SQL relationships in SQL server 2008!

问题描述

我已经创建了几个表，如下所示.

I have created several tables like stating at the below.

CREATE TABLE AUTHOR(AUTHOR_NUMBER VARCHAR(6),LAST_NAME VARCHAR(25),FIRST_NAME VARCHAR(25), PRIMARY KEY (AUTHOR_NUMBER))

CREATE TABLE BOOK(BOOK_CODE VARCHAR(6),TITLE VARCHAR(50),AUTHOR_NUMBER VARCHAR(6),PAPER_BACK BIT,BOOK_TYPE VARCHAR(25),UNITS_ON_HAND INT,PRICE MONEY,PUBLISHER_DATE DATETIME, PRIMARY KEY(BOOK_CODE))

CREATE TABLE BOOK_ORDER(BOOK_CODE VARCHAR(6),CUSTOMER_NUMBER VARCHAR(8),ORDER_DATE DATETIME, PRIMARY KEY (BOOK_CODE,CUSTOMER_NUMBER))

CREATE TABLE CUSTOMER(CUSTOMER_NUMBER VARCHAR(8),LAST_NAME VARCHAR(25),FIRST_NAME VARCHAR(25),CUSTOMER_ADDRESS VARCHAR(50),PHONE_NUMBER VARCHAR(10), PRIMARY KEY(CUSTOMER_NUMBER))

CREATE TABLE PUBLISHER(PUBLISHER_CODE VARCHAR(8),PUBLISHER_NAME VARCHAR(50),ORDER_DATE DATETIME,NOTE TEXT, PRIMARY KEY(PUBLISHER_CODE))

之后，我想在Author表Author_Number&之间建立关系.图书表的作者编号，我已经在MS SQL Server 2008中声明了以下SQL语句，如下所示.

After that I wanted to create a relationship between Author table Author_Number & Book tables''s Author Number and I have declared the following SQL statement in MS SQL server 2008 as the following.

ALTER TABLE BOOK ADD CONSTRAINT FK_AUTHOR_NUMBER FOREIGN KEY (AUTHOR_NUMBER) REFERENCES AUTHOR (AUTHOR_NUMBER) ON UPDATE CASCADE ON DELETE CASCADE)

但是当我执行该语句时，出现以下错误.

第15层状态1线1消息102
'')''附近的语法不正确.

请尝试解决我的问题. Thanx

But when I executed the statement I got the following error.

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '')''.

Please try to solve my problem. Thanx

推荐答案

您有一个额外的开放式括号.试试这个:

You had an extra open bracket. try this:

ALTER TABLE BOOK
    ADD CONSTRAINT FK_AUTHOR_NUMBER
    FOREIGN KEY (AUTHOR_NUMBER) REFERENCES AUTHOR (AUTHOR_NUMBER) ON UPDATE CASCADE ON DELETE CASCADE

这篇关于在SQL Server 2008中创建SQL关系！的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！