To Toad for SQL Server community
shortcut key Alt-F1
shortcut key like Alt-F1 in SSMS to view table, views...detail information
Browse Recent Ideas
-
I agree
0 votes
This idea is active.SQL Editor »Add your comment for Idea: shortcut key Alt-F1 -
I agree
0 votes
This idea is active.Schema Compare »Schema Compare report to include detailed comparison result.
Add your comment for Idea: Schema Compare report to include detailed comparison result.Schema Compare report to include detailed comparison result. Currently this is only a summary report. Request to include comparison result for each object as well.
-
I agree
2 votes
This idea is in review.SQL Editor »Right Click Generate SQL to Editor at Cursor Position
Add your comment for Idea: Right Click Generate SQL to Editor at Cursor PositionWhen 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.
-
I agree
2 votes
This idea is active.Object Explorer / Schema Browser »Default Value Constraint Name
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 »
4 comments for Idea: Default Value Constraint NameI 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 »
-
I agree
2 votes
This idea is active.Just something cool or urgent »Schema column needed in Object Search results
Add your comment for Idea: Schema column needed in Object Search resultsA "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.
-
I agree
2 votes
This idea is active.SQL Editor »Transpose / Pivot Results
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 »
1 comment for Idea: Transpose / Pivot ResultsWhen 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 »
-
I agree
2 votes
This idea is in review.SQL Editor »Make Group Execute available by default for all editor windows
1 comment for Idea: Make Group Execute available by default for all editor windowsMake 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.
-
I agree
4 votes
This idea is active.Just something cool or urgent »SQL Server Compact Support
2 comments for Idea: SQL Server Compact SupportIt 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.
-
I agree
1 vote
This idea is active.Import/Export data »Kamran
2 comments for Idea: KamranROW NUMBER SHOULD BE PROVIDED FOR SQL SERVER 2000 DATABASE WHILE MIGRATING DATABASE FROM LEGACY SERVERS TO NEW
-
I agree
3 votes
This idea is active.Import/Export data »Progress Bar When Selecting Large Text Files
Add your comment for Idea: Progress Bar When Selecting Large Text FilesWhen 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.
-
I agree
3 votes
This idea is in review.Just something cool or urgent »Alter Table syntax need to move Index Creation after Insert
Add your comment for Idea: Alter Table syntax need to move Index Creation after InsertOn 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.
-
I agree
1 vote
This idea is active.Just something cool or urgent »SVN - include Drops part
Add your comment for Idea: SVN - include Drops partHi,
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
-
I agree
2 votes
This idea is active.Object Explorer / Schema Browser »View/Edit - Extended properties from columns
2 comments for Idea: View/Edit - Extended properties from columns
It would be wonderful to edit the extended properties from columns (tables/views).
-
I agree
1 vote
This idea is active.Object Explorer / Schema Browser »Script generation - Extended Properties from columns
1 comment for Idea: Script generation - Extended Properties from columnsAdd the ability to append also the extended properties from columns (tables / views).
--> Object Details --> Tab: Script --> Script Options: Extended properties
-
I agree
3 votes
This idea is active.Just something cool or urgent »Schema Repport should be more flexible
1 comment for Idea: Schema Repport should be more flexibleThe 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...)
-
I agree
1 vote
This idea is active.Just something cool or urgent »Health Check Reports
2 comments for Idea: Health Check ReportsI would like to see Health Reports for SQL Server similar to what we have in TOAD for Oracle.
-
I agree
1 vote
This idea is active.Just something cool or urgent »Mercurial DVCS Support
Add your comment for Idea: Mercurial DVCS SupportNeed support for Mercurial version control. Bitbucket, Kiln, local etc.
-
I agree
8 votes
This idea is active.SQL Editor »Execution Plan should work with variables
3 comments for Idea: Execution Plan should work with variablesExecution Plan should work with variables.
Test SQL: select 'test' where '' = :par1
-
I agree
4 votes
This idea is in review.Object Explorer / Schema Browser »Quick Jump To Column In Viewer Table Using Object Explorer
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 »
4 comments for Idea: Quick Jump To Column In Viewer Table Using Object Explorer
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 »
-
I agree
2 votes
This idea is active.SQL Editor »Table Description
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 »
Add your comment for Idea: Table DescriptionTo 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 »
-
I agree
4 votes
This idea is in review.Just something cool or urgent »Report settings used from printer...
1 comment for Idea: Report settings used from printer...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...
-
I agree
3 votes
This idea is active.Just something cool or urgent »Add Code Snippits for DMV (2008 R2 and beyond)
Add your comment for Idea: Add Code Snippits for DMV (2008 R2 and beyond)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
-
I agree
4 votes
This idea is active.Data Compare »Optional Identity Insert By Table
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 »
Add your comment for Idea: Optional Identity Insert By TableWhen 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 »
-
I agree
4 votes
This idea is active.Import/Export data »Export to EXCEL - allow formatting
Add your comment for Idea: Export to EXCEL - allow formattingIt 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.
-
I agree
5 votes
This idea is active.Import/Export data »One click export should remember last save location
Add your comment for Idea: One click export should remember last save locationPlease make Toad remember the last save location for one click export (I mean right click on grid > Quick export > File). Default foder for one click export is always "my documents" in XP. This is annoying.
Social Web