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

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

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.
bdroye
0

Comments

3 comments

Sort by
  • James R
    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!

    Thanks,
    James
    James R
    0
  • broye
    James I will give this a try and report my findings. Thanks.
    broye
    0
  • SG27_HYTEK
    This worked for me.  Thanks!
    SG27_HYTEK
    0

Add comment

Please sign in to leave a comment.