TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Abhishek Hariharan
NA
4
0
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
Reply
Answers (
2
)
Could not bulk insert. File ' @PathFileName ' does not exist.
How to save bold text in the sql, server 2005