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
Loading
Abhishek HariharanPosted Jan 15, 2009, 2:02 PM
Vijaya KadiyalaPosted Apr 10, 2008, 12:18 PM
Hi,
There is no way you can do this.
Thanks -- Vj