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

Autocomplete when schema is not [dbo]

amSteveamSteve Posts: 5 New member
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.


Sign In or Register to comment.