Altaf Patni
asked on
how to copy table structure from one Database to another database
How to copy tables structure from one Database and paste to another database
i am newbie for SQL Server 2008 R2
i am newbie for SQL Server 2008 R2
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for quick answer. :-)
ASKER
If the tables don't exist it will create them for you, but you'll probably have to recreate any indexes and such. If the tables do exist, it will append the new data by default but you can adjust that (edit mappings) so it will delete all existing data.
above solution is working for me.. thanks