Using constraints in SQL Server 2005?

Hot Topic

Problems with SQL 2005 Export Wizard
Unable to change results format without closing query window.
Deploy Problem--failed with big files!
Slow changing dimension help
Nested SELECT ... FOR XML PATH Return ESCAPED <>s
Merge disparate queries into raw file
Query Designer Toolbar
ON SCHEMA :: schema_name
MSDTC - The Transaction Manager is not available
Problem with SQL 2000 on Windows CLUSTERING

SQL Server

A transport-level error has occurred when sending the request to the server
MSDE or SQL 2005 Deployment resources - real world input
Client-side redirect
Problems setting File Share Subscriptions in Reporting Services SQL 2000
How can I get Transactional Republishing to work?
still cannot run my job
VBA IsError function in MDX with SQL Server 2005
Scripting: Dumb Q.. How can I store a DTS variable inside a script variable?
How to Connect to Analysis Services from Client Management Studio?
SSIS Auto Documentation

Using constraints in SQL Server 2005?

Hello!

I'm new to using SQL Server 2005 and I'm having problems with a SQL Query. The query is:

CREATE TABLE Deliveries(

S CHAR(2) NOT NULL,

P CHAR(2) NOT NULL,

QTY SMALLINT NOT NULL,

PRIMARY KEY (S,P)

CONSTRAINT FKSuppliers

FOREIGN KEY (S) REFERENCES Suppliers(S),

CONSTRAINT FKProducts

FOREIGN KEY (P) REFERENCES Products(P)

)


When I run it I get the message:

Incorrect syntax near the keyword 'CONSTRAINT'.

I'm not sure if a column can be both Primary- and Foreign Key And I'm not sure if SQL SERVER supports all the SQL I'm using (of if I'm using it the right way).

Thanks in advance!

Answer this question

Using constraints in SQL Server 2005?

  • Galen Murdock

    Hello again!

    Thanks! Now it all works great ;)

  • minton

    You missed keywords  CONSTRAINT PK_Deliveries ..This compiled fine in my system.

    CREATE     TABLE Deliveries(

    S CHAR(2) NOT NULL,

    P CHAR(2) NOT NULL,

    QTY SMALLINT NOT NULL,

    CONSTRAINT PK_Deliveries PRIMARY KEY (S,P),

    CONSTRAINT FKSuppliers

    FOREIGN KEY (S) REFERENCES Suppliers(S),

    CONSTRAINT FKProducts

    FOREIGN KEY (P) REFERENCES Products(P)

    )

  • Using constraints in SQL Server 2005?
Answer this question