Home Forums SQL Server 2016 SQL Server 2016 - Administration Exporting data with primary keys RE: Exporting data with primary keys

  • February 19, 2018 at 7:12 am

    #1980267

    tmmutsetse - Monday, February 19, 2018 6:51 AM

    Good day,

    I want to export data from one table to another using export and import wizard,i realised that the primary keys are not exported ,Is there a way to play around it  without scripting the table first.

    Thanks

    Why do you not want to script the table?  If you don't, though, then just script the primary key constraint. Expand the table, expand Keys, right-click on the primary key constraint and choose Script Key as -> CREATE To -> Clipboard.

    John