hi <BR> Is there a way to copy the tables from one database to another on the same SQl server with all the key information and the relations?<BR>when ever i do an import , I just get the data without the relations? <BR>i can get this done with the help of a query, but is there a way to get this done using the enterprise manager<BR>pls let me know<BR>thx