I have had this problem too when copying table from one sql server to another. Im assuming your using the Data Import/Ecport wizard, which asks if you want to copy tables or copy objects. If you select copy tables, it does only that. You need to select copy objects to get it to include the indexes and relationships.

Eric

>I have to create database that made from importing Ms. Access 2000 MDB files into Ms. SQL 2000, it's done already with no errors but I do not understand why the index keys and also primary keys are not also imported... any solutions thanks
>
>Regards
>Teddy