Create view with specific owner

I'm distributing an application commercially, I hope. My installer needs to create a SQL database (called newDB), tables, functions,  and views.

Which is better:

use newDB
go
create view viewName as select field1 from ExistingdbName.dbo.tableName
or

use newDB
go
create view viewName as select field1 from ExistingdbName..tableName

I know that under most circumstances the result is the same, but I don't want to be sloppy about it by making that assumption. Should my installation program ask the user for the owner of ExistingdbName? with a default to dbo?
LVL 11
stevengraffAsked:
Who is Participating?
 
MohammedUConnect With a Mentor Commented:
It will not ask the db owner but definitely object owner...
In this case View...
I will adivise you use schema name when you are creating the objects like view/table etc...

create view dbo.viewName as select field1 from ExistingdbName.dbo.tableName
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.