modify database db1 * This would show tables and views right ? * Dblclick on your view would pop it up in designer * and you would copy the SQL - you have done this part * suppose your select statement is : * select * from db1!table1 open database db2 * With pasting your command would be : create sql view myview as ; select * from db1!table1 modify view myview && You should see your viewThis copies view between DBCs. If you mean you want to use same DBC in different projects then just add the DBC to project.