• The keys and indexes are part of the table definition and are not contained in the data, to obtain this information right click on the source table and click on script table --> creaat to --> new query window.

    this will provide you with the script that is used to build the table and the keys and indexes.

    If the indexes are not contained in this script, you may need to check the option under..

    tools--> options --> sql server option explorer --> scripting..

    Apply the relevant part of the scripts to the destination table