Link to home
Create AccountLog in
Avatar of wantime
wantime

asked on

MSSQL 2005 database schema: what is the different between dbname.dbo and dbname

hi all,

i have create a database with name "dbname" in MSSQL Server 2005.

as i use hibernate to manipulate the database, i was asked to tell the database schema.

in one computer i must use "dbname" as database schema, in another one i must use "dbname.dbo" as database schema.

i would like to know what is the different between dbname.dbo and dbname. how can i find which database schema is used in MSSQL Server?

thanks,

wantime
Avatar of chapmandew
chapmandew
Flag of United States of America image

dbo is always the implied (default) schema for databases.  So, when you leave the schema out, dbo is used in its place.
ASKER CERTIFIED SOLUTION
Avatar of valkyrie_nc
valkyrie_nc
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
(or, what chapmandew said :) )
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account