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

broye

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.

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

broye

James I will give this a try and report my findings. Thanks.

SG27_HYTEK

This worked for me.  Thanks!