search using partial table names

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

search using partial table names

Postby klininger » Mon Feb 01, 2010 6:15 pm

Is there a way to search for a partial database name besides the default of "table name starts with"?

The databases we work with have between 400 and 1300 tables. Without getting into the need to slim the database (out of our hands at the moment), you can see why I'd like this feature.

Thanks!

Kurt
klininger
 
Posts: 5
Joined: Mon Feb 01, 2010 6:10 pm

additional info

Postby klininger » Mon Feb 01, 2010 6:30 pm

I should add that I'm specifically asking about when one types

select * from {cursor here}

Would be nice to be able to type %something% and get all tables with "something" in the name
klininger
 
Posts: 5
Joined: Mon Feb 01, 2010 6:10 pm

Postby peter.peart » Wed Feb 03, 2010 10:57 am

Hi Kurt,

If I am understanding this correctly, you would like to create a SELECT statement, and be able to select multiple tables to pull information from using SQL Prompt, and have it automatically insert joins for you to?

For example, if we use the below code:

Code: Select all
USE AdventureWorks
GO
SELECT * FROM  Person.Contact
JOIN Sales.ContactCreditCard ON Person.Contact.ContactID = Sales.ContactCreditCard.ContactID


You would expect to type in Prompt:

Code: Select all
SELECT * FROM %contact%


And then select all the tables with "contact" in and have Prompt automatically create the join in the previous code snippet?

Many thanks!

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby klininger » Wed Feb 03, 2010 1:58 pm

Peter,

Thanks for the reply!

Actually, my first real need is to select just one table from a vey long list of tables. Many of the tables have the same very long (10 character) prefix. This means that currently, even with SQL Prompt, I will have to either type the whole prefix, or wade thru a long list.

Even for tables with no prefix, Many times I remember the end of the table name but not the beginning. This would be another case where searching for a partial name would help in finding one table for a simple SELECT.

Thanks again for helping.

Kurt
klininger
 
Posts: 5
Joined: Mon Feb 01, 2010 6:10 pm

Postby peter.peart » Fri Feb 05, 2010 3:11 pm

Hi Kurt,

Many thanks for clarifying this, I have added a feature request in the system for this under SP-2912. I am sure it will be considered for a future release of the tool.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Feature Request

Postby klininger » Fri Feb 05, 2010 4:21 pm

Thanks Pete

You may be able to imagine (because of our environment mentioned above) that this feature was actually the one thing I was looking for in a "SQL Prompt"-like program.

Thanks for adding that.

Kurt
klininger
 
Posts: 5
Joined: Mon Feb 01, 2010 6:10 pm

Postby MikeONeill » Sun Feb 14, 2010 11:05 am

I posted a similar request fro using Camel case shortcuts

eg BatchValueView would be accessed by <bvv> , as you see in Visual Assist X etc ie filtering on the Camel Case capitals

Looks like 2 votes

Mike
MikeONeill
 
Posts: 131
Joined: Wed May 24, 2006 7:31 am

Postby peter.peart » Mon Feb 15, 2010 3:28 pm

Hi Mike,

Thanks for that, I have added your comments too to the feature request logged under SP-2912.

Pete
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Also looking for this feature SP-2912

Postby hdomer » Fri Apr 16, 2010 5:47 pm

Please put my company down for this feature, SP-2912, as well. Many people here have talked about it.

Thanks
hdomer
 
Posts: 2
Joined: Mon Jan 25, 2010 8:06 pm

Where is the setting

Postby sriramphani » Fri Apr 16, 2010 6:01 pm

Where should I configure in order to get full table name when typing partial table name?

Thanks,
Sriram.
sriramphani
 
Posts: 5
Joined: Fri Apr 16, 2010 5:35 pm
Location: Houston, TX

ETA

Postby klininger » Thu Aug 05, 2010 10:01 pm

Peter,

Practically every day I wish I could use SQLPrompt. I won't be able to sell the idea without this feature, though. Do you have an idea when this feature could possibly be implemented?

Thanks!

Kurt
klininger
 
Posts: 5
Joined: Mon Feb 01, 2010 6:10 pm

Postby David Atkinson » Fri Aug 06, 2010 12:17 am

Unfortunately we can't say at this point when the feature will be implemented. The backlog for v5 has already been finalized, and the project is currently in full swing. However, we will consider this for v6 alongside all the other requests we get. The more popular this one proves to be, the more likely we'll consider implementing it!

Thanks for voicing your views!

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby CodantiM » Thu Aug 12, 2010 12:53 am

David Atkinson wrote:Unfortunately we can't say at this point when the feature will be implemented. The backlog for v5 has already been finalized, and the project is currently in full swing.


Any chance you can share what SP-IDs have made the cut and are planned to get included/fixed in v5? (I have my list of 27 pet bugs/suggestions that I would like to see fixed.)
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am

Postby David Atkinson » Thu Aug 12, 2010 8:51 am

The next release is very focused on the implementation of three new features.

1) Show Dependencies (including at column level)
2) Find Invalid Objects (objects that reference objects that no longer exist)
3) Script as Alter (right click on your object in a query window and script it as Alter to a new query window)
4) All SQL Refactor features will be integrated into SQL Prompt 5

Other than for critical bug fixes, we're not planning to enhance code completion or formatting for v5.

If you're interested in trying out v5 early access builds, let me know and I'll put you on our distribution list.

Kind regards,

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Re:

Postby CodantiM » Thu Aug 12, 2010 4:48 pm

David Atkinson wrote:The next release is very focused on the implementation of three new features.

1) Show Dependencies (including at column level)
2) Find Invalid Objects (objects that reference objects that no longer exist)
3) Script as Alter (right click on your object in a query window and script it as Alter to a new query window)
4) All SQL Refactor features will be integrated into SQL Prompt 5

Other than for critical bug fixes, we're not planning to enhance code completion or formatting for v5.

If you're interested in trying out v5 early access builds, let me know and I'll put you on our distribution list.


David,

When does Reg Gate plan on focusing on fixing the identified and confirmed bugs in SQL Prompt? While v4 introduced some new features it also introduced a lot of new bugs that still haven't been fixed, along with bugs from v3 that are still in there. Should we expect the same with v5, new features but even more bugs and broken existing functionality?
CodantiM
 
Posts: 182
Joined: Fri Jun 29, 2007 2:07 am


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests