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) A socialist is someone who will give you the shirt off *someone else's* back.

  • 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