Is there a find the actual sql statement behind a view. I am in sql management studio, i right clicked on the view and i dont see an option to reveal the sql behine the view.
Views -> your view -> Script View As -> Create
you can also do
SELECT OBJECT_DEFINITION (OBJECT_ID(N'your view'));
Right click the view and Design...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With