I notice SQL server use 4 part name, such as:
servername.databasename.ownerName.TableName
When it comes to these INFORMATION_SCHEMA.TABLE or INFORMATION_SCHEMA.VIEWS,
does INFORMATION_SCHEMA represent a owner?
Thanks.Yes, INFORMATION_SCHEMA is the owner. This name part is also sometimes
referred to as 'schema'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"light_wt" <lightwt@.discussions.microsoft.com> wrote in message
news:2EB25B71-D861-4B03-9846-C322A79C90EA@.microsoft.com...
>I notice SQL server use 4 part name, such as:
> servername.databasename.ownerName.TableName
> When it comes to these INFORMATION_SCHEMA.TABLE or
> INFORMATION_SCHEMA.VIEWS,
> does INFORMATION_SCHEMA represent a owner?
> Thanks.|||Thx! :)
"Dan Guzman" wrote:
> Yes, INFORMATION_SCHEMA is the owner. This name part is also sometimes
> referred to as 'schema'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "light_wt" <lightwt@.discussions.microsoft.com> wrote in message
> news:2EB25B71-D861-4B03-9846-C322A79C90EA@.microsoft.com...
> >I notice SQL server use 4 part name, such as:
> > servername.databasename.ownerName.TableName
> >
> > When it comes to these INFORMATION_SCHEMA.TABLE or
> > INFORMATION_SCHEMA.VIEWS,
> > does INFORMATION_SCHEMA represent a owner?
> >
> > Thanks.
>
>sql
Wednesday, March 21, 2012
Is that an owner from two part name?
Labels:
database,
databasename,
information_schema,
microsoft,
mysql,
oracle,
owner,
ownername,
server,
servername,
sql,
table,
tablename
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment