Posted by serge on 12/05/35 11:36

I am doing a mass update of our SQL script files by adding dbo.
to all references to the tables.

The code is also adding dbo. in front of existing lines of code
that are like this:

SELECT CLIENT.FIRSTNAME,
CLIENT.LASTNAME
FROM CLIENT
....

The mass update is causing this to become:

SELECT dbo.CLIENT.FIRSTNAME,
dbo.CLIENT.LASTNAME
FROM dbo.CLIENT
....

My goal is to see FROM dbo.CLIENT
but even the column names are getting the "dbo."
added, so my question is if there's any performance
loss or any other side effect if I end up all my columns
with a preceeding "dbo."?

Thank you

[Back to original message]