Autocomplete when schema is not [dbo]

amSteve

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.

RichardL

Hi @amSteve

Thanks for your post. 

Which version of SQL Prompt are you currently running? 

Best

Richard Lynch. 

amSteve

I'm using 9.1. Thx

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.