Posted by serge on 11/04/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

• Next in forum: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
• Prev in forum: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
• Thread view: Is there any performance loss if i have all my columns preceeded with dbo.Tablename?

[Reply to this message]