distal-attribute
distal-attribute
distal-attribute
distal-attribute

"Create" tab for triggers and views

User, date Message
Written by microUgly
3 years ago
Category: General
20 posts since Fri, 16 Apr 10
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.
Written by ansgar
3 years ago
4973 posts since Fri, 07 Apr 06
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"
Written by microUgly
3 years ago
20 posts since Fri, 16 Apr 10
Excellent. Thankyou :)
 

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