Hi friends,
Is there any way to copy a view from one database to another
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Prabhu RajaPosted Nov 21, 2011, 5:25 AM
Jean PaulPosted Nov 21, 2011, 5:13 AM
If you wanted View data, as view is only virtual data, you need to copy the underlying tables.
In case you need a table with view data, you can use the SELECT INTO sql for that.