I believe this is an Issue, but would like to extend into Enhancments...
When doing a Detail Window of Objects in Oracle (e.g. Table, View, etc.) the columns presented are: Schema, Name, % Free, % Used, Tablespace ,Partitioned, Organization, Created, Last Modified, Last Analyzed
When doing a Detail Window of Objects in SQL Server, the columns presented are: Owner, Name, Filegroup, Created
I would like to see "at least" a Last Modifed column also appear, I know for SQL2000 this may have to be the same date as Created, but for 2005,2008,2012 the Last Modified Date is available (sys.objects or sysobjects).
Now for the Enhancment, when you Right-Click on the Object in the Detail Window, I would like to see the same Context Menu you would see if you right-clicked on the Tree in the Servers window. For example if I click on a Table, I get the options to Script the object out, this would be very useful to be able to do from the Detail window as well.
|
33 KB
|
17 KB
|
19 KB
|
25 KB
|
58 KB
Ivan - lets add Last modified for sql server
Lets discuss the complexity for the Right click enhancement
Last modified date is now extracted and displayed in details model for tables and views. Let me know if you want the last modified dates for any other objects...
Will log a new issue for the menu additions and link it to this issue...
Last modified date is now extracted and displayed in details model for tables and views. Let me know if you want the last modified dates for any other objects...
Will log a new issue for the menu additions and link it to this issue...
Could you please add to all objects.
One of the ways I use this, is to look for changes to objects, so we have used for Tables, Views, Stored Procedures and Functions. But would be nice to see for the others if possible:
Indexes, Triggers, Users, Roles, etc.
Could you please add to all objects.
One of the ways I use this, is to look for changes to objects, so we have used for Tables, Views, Stored Procedures and Functions. But would be nice to see for the others if possible:
Indexes, Triggers, Users, Roles, etc.
will work on stored procedures and functions next. If no complications come up, will try to finish all the tree node objects for version 13. <- will attempt to extract and show for all tree objects ->
will work on stored procedures and functions next. If no complications come up, will try to finish all the tree node objects for version 13. <- will attempt to extract and show for all tree objects ->
checking in changes for tables, views, synonyms, stored procedures, functions. The changes touch a lot of the core extraction code and is requiring lots of testing for the QA labs. Will be filling a new issue for the rest of the objects in version 14, so it can go through a more thorough test cycle.
checking in changes for tables, views, synonyms, stored procedures, functions. The changes touch a lot of the core extraction code and is requiring lots of testing for the QA labs. Will be filling a new issue for the rest of the objects in version 14, so it can go through a more thorough test cycle.
Verified in ADS v13.0.3-19 for Tables, Views, Synonyms, Stored Procedures, Functions, Users and Roles
Verified in ADS v13.0.3-19 for Tables, Views, Synonyms, Stored Procedures, Functions, Users and Roles
Issue #9714 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v13.0.3-19 |
No time estimate |
2 issue links |
relates to #9718
Issue #9718Detail Window - Enhancement - new menu options |
relates to #9733
Issue #9733Issue/Enhancement - Detail Window |
Ivan - lets add Last modified for sql server
Lets discuss the complexity for the Right click enhancement