Sql-server – Copying View in Management Studio

sql serverssms

I want to copy a VIEW from one server to another. I could copy tables but I can't copy views. Is there a way to do so?
Thanks

Best Answer

The easiest way if you just want to do a quick CREATE VIEW on your destination server would be to script it out:

  1. Right-click your view
  2. Script View as -> CREATE to -> (select your choice here)

The possible choices as a destination for the CREATE VIEW script can be a new query window, a file, the clipboard, or an agent job. If you need to run this create script at a later date, the file destination is probably your best bet. But if you want to run it immediately, and you have access to the server, just script it to a new query window and connect to your destination instance/database and run the CREATE VIEW script.

Related Question