"Create" tab for triggers and views

microUgly posted 6 years ago in General
I see that procedures and functions have "create" tabs to show code for creating them.

Is it possible to get this for triggers and views?

We have our product on many servers, so it's handy when we do an update that we can easily grab the create code from a reference database. Especially when the upgrades are being performed by staff less familiar with the syntax of these commands.
ansgar posted 6 years ago
You could also use the export to clipboard feature:
1. right click the view or trigger or whatever
2. click "Export database..."
3. select output "Clipboard", no data, create tables
4. press "Export"
microUgly posted 6 years ago
Excellent. Thankyou :)

Please login to leave a reply, or register at first.