"Create" tab for triggers and views
| User, date | Message |
|---|---|
|
Written by microUgly
2 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
2 years ago 3954 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
2 years ago 20 posts since Fri, 16 Apr 10 |
Excellent. Thankyou :) |
|
Please login to leave a reply, or register at first. |