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...
>
>
No comments:
Post a Comment