SyntaxFix

[sql-server] Creating composite primary key in SQL Server

How about something like

CREATE TABLE testRequest (
        wardNo nchar(5),
        BHTNo nchar(5),
        testID nchar(5),
        reqDateTime datetime,
        PRIMARY KEY (wardNo, BHTNo, testID)
);

Have a look at this example

SQL Fiddle DEMO

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to primary-key

• Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object • What is Hash and Range Primary Key? • Can I use VARCHAR as the PRIMARY KEY? • Can a foreign key refer to a primary key in the same table? • UUID max character length • MySQL duplicate entry error even though there is no duplicate entry • Creating composite primary key in SQL Server • What are the best practices for using a GUID as a primary key, specifically regarding performance? • Add primary key to existing table • Create view with primary key?