Display the schema

emoreau · November 27, 2007 8:32AM

Hi

Is it possible to display the schema when displaying the list of tables? I have tables that are having the same name in different schema, your tool correctly match them but when I select items, I need to know the schema to select the one I want.

Chris Spencer · November 27, 2007 1:55PM

Hi

I can see the problem you are having and have subsequently raised an enhancement request internally.

However, I'm unable to give any timescale at the moment as to when it may get done.

Regards
Chris

keymoo · April 2, 2008 6:11AM

Chris Spencer wrote:

Hi

I can see the problem you are having and have subsequently raised an enhancement request internally.

However, I'm unable to give any timescale at the moment as to when it may get done.

Regards
Chris

Hi Chris,

Any idea when this feature will be released? I have many schemas in my database and some of them have tables with the same name. This feature should be treated as urgent.

Thanks!
keymoo

David Atkinson · April 2, 2008 8:48AM

Hi Keymoo,

Thanks for your comment. An undocumented feature of the Filter field (in the top right hand corner of Tables and Views) is that is filters on the fully qualified object name (you need to specify the square brackets []). So if you want to filter the list with only objects belonging to schema 'myschema', type the following into the filter field:

[myschema]

If you want only objects in myschema beginning with the letter x, type the following:

[myschema].[x

Does this help you work around your problem? Please let me know how you get on.

David Atkinson
Product Manager
Red Gate Software

keymoo · April 4, 2008 5:52AM

Thanks David - that does help a lot. However, I'd still prefer to be able to see a column for the schema as you do in SQL Compare (although you still call it owner).

I'd like to submit that as a feature request (and call the column schema, not owner).

keymoo

Michelle T · April 4, 2008 6:28AM

The problem with calling the column 'schema' is that in SQL Server 2000, which we still support, 'schema' is not the correct term. 'owner' is nearly correct for both the 2000 and the 2005/8 way of doing things, rather than entirely correct for one and incorrect for the other.

Display the schema

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk