search using partial table names

[klininger]

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]

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

[peter.peart]

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:

[klininger]

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

[peter.peart]

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

[klininger]

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

[MikeONeill]

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

[peter.peart]

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

[hdomer]

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

Thanks

[sriramphani]

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

Thanks,
Sriram.

[klininger]

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

[David Atkinson]

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

[CodantiM]

[David Atkinson]

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

[CodantiM]