Click here to Skip to main content
15,793,624 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello. Is it possible to code a SQL query that automatically copies one database's schema(constraints, tables etc without any data stored in the row x columns) to another database's schema without using 'Generate Scripts' in SQL Server? If so, any tips how to do it? I'm thinking of using Catalog views->sys.schemas but i can't implement it.
Thanks in advance.
Updated 10-Sep-14 2:03am

1 solution

Share this answer
Gihan Liyanage 10-Sep-14 7:08am    
Thanx for removing the comment, after you read whole article..
YourAverageCoder 10-Sep-14 7:12am    
No problem. Thanks for solution.
Gihan Liyanage 10-Sep-14 7:25am    
You are welcome..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900