Copy columns from one table and database to another table and database
Posted on 2014-12-02
Is there any short way to copy a table with no data (just columns) from one database to another table from another database using MSSQL 2008?
I tried doing design table, and than on Edit, i selected copy the columns but when I go to add a new table on another database and paste the columns, it does pasta all row fields in one row. Is there anything I am doing wrong.