Assigning or Changing a Schema name

Mar 2 2008 2:52 AM
Hello everyone. I wanted to learn to assign and change a schema names used in my table. I dont want a dbo. in my tables. I want to give a personal name like the adventureworks database has. (Such as sales.salesdetails, humanresources.employee and all)

> So how i do create a table with a schema name sales
and
> So how do i change my for example dbo.employee to sales.employee ??

I tried
Create table sales.employee
{
statements
}

but it doesnt work...
Please reply ASAP

Thanks

Answers (2)