Change Default owner 'Username' to 'dbo'

• shubham.saxena67

  Default port

  Points: 1490

  More actions

  July 8, 2011 at 2:06 am

  #253409

  Hello friends,

  I have created a database with name caspa_in_caspa that is associaded with a user caspa_in_caspabareilly and

  when we are creating table in database caspa_in_caspa though query it is created as caspa_in_caspa.tablename but we want it should be dbo. tablename. plz resolve it asap..

  Sir We are executing following query:

  create table ttt

  (id int)

  table created as:caspa_in_caspabareilly.ttt(That is not required)

  table should be created as:dbo.ttt(That is required)

  Note::This will create like:caspa_in_caspabareilly.ttt that is username.tablename

  but we want to create table like dbo.table name

  we are waiting for your reply..

  Thanks..

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  July 8, 2011 at 2:46 am

  #1350200

  look up this article

  http://msdn.microsoft.com/en-us/library/aa259622%28v=sql.80%29.aspx

  Jayanth Kurup[/url]

• anil_kumar32

  Ten Centuries

  Points: 1378

  More actions

  July 8, 2011 at 3:18 am

  #1350214

  [font="Times New Roman"]

  Hi,

  You may try something like:

  CREATE TRABLE dbo.tblName (id INT)

  Regrads,

  Anil

  [/font]

• Orlando Colamatteo

  SSC Guru

  Points: 182279

  More actions

  July 12, 2011 at 5:07 pm

  #1351942

  shubham.saxena67 (7/8/2011)

  ---

  Hello friends,

  I have created a database with name caspa_in_caspa that is associaded with a user caspa_in_caspabareilly and

  when we are creating table in database caspa_in_caspa though query it is created as caspa_in_caspa.tablename but we want it should be dbo. tablename. plz resolve it asap..

  Sir We are executing following query:

  create table ttt

  (id int)

  table created as:caspa_in_caspabareilly.ttt(That is not required)

  table should be created as:dbo.ttt(That is required)

  Note::This will create like:caspa_in_caspabareilly.ttt that is username.tablename

  but we want to create table like dbo.table name

  we are waiting for your reply..

  Thanks..

  When executing a CREATE TABLE where the table name is not schema-qualified SQL Server opts to create the table in the database user's default schema.

  You can change the default schema for any database user to dbo (or anything you like) with an ALTER USER statement like this:

  ALTER USER user_name WITH DEFAULT_SCHEMA = dbo;

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato

• shubham.saxena67

  Default port

  Points: 1490

  More actions

  July 13, 2011 at 1:43 am

  #1351988

  Hi Friend,

  You Are Great you completely understand my problem

  and you have fully solved the issue.

  I am so much thankful to you to spent your valuable time to solve my query.

  T

  H

  A

  N

  K

  S

  A LOT.