Composite Primary keys in In-Memory OLTP

• sean redmond

  SSCertifiable

  Points: 5829

  More actions

  August 14, 2018 at 3:19 am

  #415250

  Hi,
   Does anyone know if it is possible to create composite primary keys in In-Memory OLTP? I'm using SQL Server 2016. It doesn't seem to be and Microsoft isn't making it any easier with its new, improved BooksOnline.
  Thanks,
  Sean Redmond.

• ScottPletcher

  SSC Guru

  Points: 101180

  More actions

  August 14, 2018 at 10:57 am

  #2001709

  Not 100% sure, but I believe it is:

  create table ... (column1 ..., column2 ...,
  primary key nonclustered ( column1, column2 ) ) with ( memory_optimized = on )

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

• sean redmond

  SSCertifiable

  Points: 5829

  More actions

  August 14, 2018 at 11:51 pm

  #2001777

  This worked.
  Thanks very much Scott.
  Sean.