How to copy a view?

Question

SQL

Hey!
Please tell me, I have two identical databases in SQL Server 2016. I need to transfer a view from one database to another.
Thank you!

Answer 1

Sometimes a view is created at some time, and then the base changes.
And so the view may exist, but does not work.
They can be ignored.
If the bases are actually the same, this is one of those obsolete views that will not be built on the base from which you originally took it.
Maybe there are other reasons... share a copy of the error and, if it makes sense, the line that causes it.

Answer 2

https://skr.sh/i/180121/mzTN3nFO.jpg?download=1&na... 18-01-2021 17:13:02.jpg
Just execute the view creation script on the second base and that's it

Answer 3

Thanks mletov ! don't tell me, I'm getting an error. that this is not a valid name for almost all table values. what to pay attention to? thanks again!