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

How do to set up Prompt to remove schema "dbo" prefix?

broyebroye Posts: 5 Bronze 1
edited February 28, 2017 12:11PM in SQL Prompt
I would like the code that SQL Prompt creates does not have the dbo. schema prefix. Or any Schema prefix for that matter. How is this achieved? Thanks.


  • Options
    James RJames R Posts: 104 Silver 4
    Hi Broye,

    I think you're looking for the Qualification options, under SQL Prompt > Options > Inserted Code > Qualification. There is also an option to toggle Qualifying object names under SQL Prompt > Options > Format > Actions.

    However, please note that sometimes SQL Prompt will always qualify inserted object names to avoid incorrect SQL, for example when inserting into a non-default schema or when column names would be ambiguous without qualification.

    Hope this helps!

    Software Engineer
    Redgate Software
  • Options
    broyebroye Posts: 5 Bronze 1
    James I will give this a try and report my findings. Thanks.
Sign In or Register to comment.