"Create" tab for triggers and views

[expired user #4867]'s profile image [expired user #4867] posted 13 years ago in General Permalink
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's profile image ansgar posted 13 years ago Permalink
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"
[expired user #4867]'s profile image [expired user #4867] posted 13 years ago Permalink
Excellent. Thankyou :)

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