How can we help you today? How can we help you today?

Autocomplete when schema is not [dbo]

I rely on autocomplete more than I care to admit. I'm migrated my existing db where [dbo]. Where I used to be able to get AC to kick in on 'Order' and 'OrderRow' I now have multiple schemas to choose from - [sc1]; [sc2]; and so on. So the original [dbo].[Order] becomes one of '[sc1].[Order]' or '[sc2].[Order].

At this point, even if i type [sc1].Or the AC is not kicking in. I can imagine other utilities that might collapse '[sc1].' to a single keystroke but in order to make that worth doing i need to know how to get SP to fire AC when the (nonstandard) schema has been entered.
amSteve
0

Comments

3 comments

Sort by
  • RichardL
    Hi @amSteve

    Thanks for your post. 

    Which version of SQL Prompt are you currently running? 

    Best

    Richard Lynch.
    RichardL
    0
  • amSteve
    I'm using 9.1. Thx
    amSteve
    0
  • RichardL
    Hi @amSteve

    Thanks again for your reply. 

    If you haven't received a reply from the community here and have a support contract then please send us a ticket so that a dedicated support engineer can look in to this for you. 

    Kind regards

    Richard Lynch. 
    RichardL
    0

Add comment

Please sign in to leave a comment.