> How do you get a table owned by "test_admin".

> When would you deliberately choose to have a table not owned by dbo?Is it

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:uuhzcHIVGHA.5332@TK2MSFTNGP10.phx.gbl...
> I am a naive user.
>
> We have a database where some of the tables are duplicated.
> One version of the table is owned by dbo, the other is owned by
"test_admin"
>
> How do you get a table owned by "test_admin".
>
> When would you deliberately choose to have a table not owned by dbo?
>
> Is it ever safe to assume that tables will be owned by dbo?
>
> (david)
>
>

"lara169" <lara169@gmail.com> wrote in message
news:%23s3$SvKVGHA.776@TK2MSFTNGP09.phx.gbl...
>> How do you get a table owned by "test_admin".
>
> SELECT TABLE_NAME
> FROM INFORMATION_SCHMA.TABLES
> WHERE TABLE_SCHEMA = 'test_admin'
>
>
>> When would you deliberately choose to have a table not owned by dbo?Is it
> ever safe to assume that tables will be owned by dbo?
> This depends on your application. If you login as some different user say
> 'user1' , and creates a table, by default its owner is 'user1'
> Otherwise you need to explicitly specify the ownership of the table in the
> create table statement
>
> CREATE TABLE dbo.MyTable (
>
> )
>
>
>
> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
> news:uuhzcHIVGHA.5332@TK2MSFTNGP10.phx.gbl...
>> I am a naive user.
>>
>> We have a database where some of the tables are duplicated.
>> One version of the table is owned by dbo, the other is owned by
> "test_admin"
>>
>> How do you get a table owned by "test_admin".
>>
>> When would you deliberately choose to have a table not owned by dbo?
>>
>> Is it ever safe to assume that tables will be owned by dbo?
>>
>> (david)
>>
>>
>
>