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

auto insert - scope of functionality

austrianfoodispukeaustrianfoodispuke Posts: 100
edited June 13, 2008 7:27AM in SQL Prompt Previous Versions
If I define an alias i.e. customers as cst in the 'auto insert' section, I would expect to then be able to do the following:

select cst.<prompt showing all columns in customers>

I would also expect to be able to do the following

FROM cst<automatically replaced with "dbo.customers cst"

Neither of which occur.

Am I missing something?


  • Options

    SQL Prompt is not designed to work that way in our current version.
    However, it is something we plan to look into for our future versions.

Sign In or Register to comment.