2 votes
When you right-click an object, and choose Generate SQL after making your selection of what to generate (ALTER Script for example), the current list of options is:
- To Editor
- To Clipboard
- To File
I'd like to see a 4th option:
- To Editor at Cursor Location
99% of the time when I'm choosing the to clipboard option i end up just pasting the script where my cursor happens to be located anyway.
5 votes
In Toad for SQL Server 5.8 when you pull up the ALTER TABLE window, you currently have the use the up and down arrow icons to move the order of the existing columns.
Request for enhancement to allow for mouse drag and drop and multi-select of columns to change the order.
2 votes
I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint. For Example: [DF__MyTable__lastM__5A30FF58] I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always ...more »
I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint.
For Example: [DF__MyTable__lastM__5A30FF58]
I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always have to watch scripts that get created with the schema change to make sure that values with those random characters are not in it, otherwise the script will fail on remote servers since they are generally different.
« less full details »
2 votes
A "schema" column in the results window of the Object Search would be great. Currently, you can't differentiate between objects with the same name appearing in different schemas within the results.
2 votes
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column. Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose. The card view in Toad was an attempt at doing that, but it fails miserably because: 1. It repeats the column names on every "card" -- ...more »
When working with tables that contain hundreds of columns but few rows, it is better to look at the data transposed with each column name as a row and with each row as a column.
Basically, the equivalent of exporting the data to Excel, selecting it, and choosing paste, transpose.
The card view in Toad was an attempt at doing that, but it fails miserably because:
1. It repeats the column names on every "card" -- wasting valuable screen real-estate.
2. It does not contain a vertical scroll bar, so if there are hundreds of columns, there's no practical way to get to them.
Desired: a new option on in the Results Window: Right-Click: Show: menu that reads: "Transposed View".
When selected, users would see data with the column names in the first column (frozen in place). Scrolling vertically displays the other columns, scrolling horizontally displays the other rows but keeps the column names visible.
« less full details »
2 votes
Make the Group Execute feature available on ALL editor tabs by default. This is a royal pain as I have to enable it per editor window.
4 votes
It would be great to have support for SQL Server Compact Edition. SQL Server Management Studio 2012 dropped support for this, and the tooling built into Visual Studio is awful. Compact Edition may not be as commonly used as the full versions, but for those who have a need for embedded databases, even limited support in a proper tool like Toad would be fantastic.
1 vote
ROW NUMBER SHOULD BE PROVIDED FOR SQL SERVER 2000 DATABASE WHILE MIGRATING DATABASE FROM LEGACY SERVERS TO NEW
3 votes
When selecing a very large Text files, Import Wizard seems to be in a wait state while it analizes the file. This can take several minutes and to the user has no idea if it is performing the task requested. Eventually, the screen will go white for a time before it returns with information about the file. A Progress Bar or just a message telling us that it is "Analyzing file..." would be helpful.
3 votes
On Table Alters where the DBA is adding a new column and putting it into a specific ordinal position (not just the end) it would BEST to avoid lengthy insert (76million rows) by moving the INDEX creation to after the insert statement. Doing so could have hours on the insert if the table is wide as well as deep regardless of the hardware.
1 vote
Hi,
it would be wonderful to have an option in version control that add the Drop section @ Check in) e.g.
/// IF exists (select * from sys.views ....
begin
drop view...
///
This option still exists in ObjectDetails -> Tab: Script
2 votes
It would be wonderful to edit the extended properties from columns (tables/views).
1 vote
Add the ability to append also the extended properties from columns (tables / views).
--> Object Details --> Tab: Script --> Script Options: Extended properties
3 votes
The schema report should be more flexible in the following cases:
- remember the last settings
- configure the look of the report (not only what it contains)
- allow to add page breaks (f. e. I like to have one table per page...)
- remove the numbers in front of the fieldnames (this numbers make the report hard to read...)
1 vote
I would like to see Health Reports for SQL Server similar to what we have in TOAD for Oracle.
1 vote
Need support for Mercurial version control. Bitbucket, Kiln, local etc.
8 votes
Execution Plan should work with variables.
Test SQL: select 'test' where '' = :par1
4 votes
I would like to see the following (only because it drives me crazy) - Under the object explorer using the tables tab, when a table is selected you get a list of fields below. I use this to see what the proper name of a field is or to see if a field exists. And if it exist I'll use the viewer table to find the column to see some values. I could use a select statement to do this but at times I want to see everything. I ...more »
I would like to see the following (only because it drives me crazy) - Under the object explorer using the tables tab, when a table is selected you get a list of fields below. I use this to see what the proper name of a field is or to see if a field exists. And if it exist I'll use the viewer table to find the column to see some values. I could use a select statement to do this but at times I want to see everything. I drives me crazy to horizontally scroll a table (350+ fields) to find a column (this is what I've inherited - NO normalizing whats so ever).
If you could allow a double click on a field in the object explorer the viewer table would go to the selected field(column) automatically - this would be very convenient.
Thanks!
Dan Borden
« less full details »
2 votes
To all: I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose. It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try. select table_name, Table_Schema,column_name, Ordinal_Position ...more »
To all:
I recently was asked to come up with a simple script to describe a table/view column and is most useful ddl attributes. The below uses the INFORMATION_SCHEMA.COLUMNS which I happen to like for this purpose.
It is very fast and very useful, I have submitted this to the Toad-SS idea pond so as to share the code. TDA and SQL Server user should give it a try.
select table_name, Table_Schema,column_name, Ordinal_Position
,DATA_TYPE
, isnull(cast(character_maximum_length as varchar(15)) ,'NA') as 'Char_Length' --- So as not to return nulls values.
, isnull(cast(NUMERIC_PRECISION as varchar(15)) ,'NA') as 'NUMERIC_PRECISION' --- So as not to return nulls values.
, isnull(cast(NUMERIC_SCALE as varchar(15)) ,'NA') as 'NUMERIC_SCALE' --- So as not to return nulls values.
, IS_NULLABLE
, isnull(cast(Column_Default as varchar(15)) ,'NA') as 'Column_Default'
from INFORMATION_SCHEMA.COLUMNS a
where table_name = 'MeterInventory' -- order by 3
« less full details »
4 votes
Reports should adapt to printer settings. In Europe we don't have "Letter"-Size Paper! We use DIN A4 as stanstd paper. Each Report can only printed after the paper size has manual changed. And this each time a report is printed...
3 votes
DMV are becoming quite popular and have a tab or groups or snippit section of DMV (Dynamic Management Views) would elevate Toad-SS into the next level already being explored by othe vendors such as RedGate and Ideara
4 votes
Using Version 5.7.0.605
I found that when you change the selection of the Constraint in the Table Constraints List, the Primary Table does not refresh until after the user mouses over the DropDownEdit Control. This is not a big issue to me, it just through me off a bit when I was naming the constraints.
4 votes
When generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis ...more »
When generating the scripts for the data compare, there is an option to turn on/off "Exclude Identity Columns". In my particular scenerio, I have some tables that need the identity columns included, then I have others that do not need them. I know that the generated script can be edited manually, but I think it would be nice to be able to specify (optionally, of course) the Exclude Identity Columns on a per table basis or for the entire script.
« less full details »
4 votes
It would be wonderful to be able to tell EXCEL that a column is a date or a number or text prior to exporting. Also a checkbox for autofiltering would be nice.
5 votes
In the "Export Finished" dialog there is an option to open the exported file (shown as a link). What I am missing there is the option to open the containing folder. Because most of the times I just want to send the exported file to someone. So I need to go to the folder, zip the export file and send it as an attachment.
To Toad for SQL Server community
Social Web