Post reply

Composite Primary keys in In-Memory OLTP

  • 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.

  • 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".

  • August 14, 2018 at 11:51 pm

    #2001777

    This worked.
    Thanks very much Scott.
    Sean.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply