With Management Studio, I created an SQL login (mylogin) then I created a schema (myschema) and finally a user (myuser) with "mylogin" as login name and "myschema" as default schema.
When I log-in and create a new table thru the Management Studio or thu a script without a schema prefix, "dbo" schema is used. Why ?
Note : as I selected "myschema" as default shema, the table has to be created in "myschema" schema. No ?
Thanks for ur future reply.