How do I make a composite key with SQL Server Management Studio?

by

enter image description here

  1. Open the design table tab
  2. Highlight your two INT fields (Ctrl/Shift+click on the grey blocks in the very first column)
  3. Right click -> Set primary key

More Related Contents:

  1. DateTime2 vs DateTime in SQL Server
  2. How to generate a range of numbers between two numbers?
  3. How to select all records from one table that do not exist in another table?
  4. SET versus SELECT when assigning variables?
  5. T-SQL dynamic pivot
  6. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  7. Generate Dates between date ranges
  8. Select group of rows that match all items in a list
  9. Add Foreign Key relationship between two Databases
  10. SQL Server check case-sensitivity?
  11. How to print VARCHAR(MAX) using Print Statement?
  12. How to assign an exec result to a sql variable?
  13. Concatenate values based on ID
  14. Query error with ambiguous column name in SQL
  15. Why (and how) to split column using master..spt_values?
  16. Splitting delimited values in a SQL column into multiple rows
  17. What does =* mean?
  18. SQL: parse the first, middle and last name from a fullname field
  19. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  20. SQL Select Upcoming Birthdays
  21. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  22. CTE error: “Types don’t match between the anchor and the recursive part”
  23. TransactSQL to run another TransactSQL script
  24. How do I remove extended ASCII characters from a string in T-SQL?
  25. Getting Dates between a range of dates
  26. The most elegant way to generate permutations in SQL server
  27. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  28. Compare dates in T-SQL, ignoring the time part
  29. SHOW ALL Dates data between two dates; if no row exists for particular date then show zero in all columns
  30. Removing duplicate rows (based on values from multiple columns) from SQL table

Leave a Comment