What are the challenges you face when working across database platforms? Take the survey

Object qualification where database name = schema name

sqlearnersqlearner Posts: 3
edited August 31, 2015 7:29PM in SQL Prompt
Using SQL Prompt, we have inherited a database where one of the schemas has the same name as the database itself. Our internal style requires table names to be qualified by schema name without database name.

When auto-completing a table name using our insertion key, SQL prompt inserts the schema and object name again such that the object is qualified as database_name.schema_name.object_name. This auto-insertion then breaks our style. Is there any way to configure SQL prompt that might avoid this behaviour? The obvious work-around is to not auto-complete, but the habit is difficult to break.

Any suggestions?

Database = 'Tools'
Schema name = 'Tools'
Table/Object name = 'Parts'

Desired: SELECT * FROM Tools.Parts
SQL Prompt Auto Complete Entry: SELECT * FROM Tools.Tools.Parts


Sign In or Register to comment.