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.