I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► KBSQL ServersMicrosoft SQ...   Print This    All Groups  
Part of the mo. lesson in the Oct 15 Issue of Prestwood eMag
DBA Code Snippet:
 A flashcard from our DBA Flashcards Library
 A code snippet from our DBA Code Snippets Page
Move Table to Another Schema

In MS-SQL, to move an object such as a table or view from one schema to another, use alter schema.


alter schema [ToSchema] transfer FromSchema.[Object] 

 

For example, the following moves the Orders table from the user1 schema t the dbo schema.

alter schema [dbo] transfer user1.[Orders] 

Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1172A1
Enter key:
Code Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile


Linked Certification Question(s)

The following are practice certification questions with answers highlighted. These questions were prepared by Mike Prestwood and are intended to stress an important aspect of this KB post. All our practice questions are intended to prepare you generally for passing any certification test as well as prepare you for professional work.

Intermediate

1 Intermediate Level Question

Question #1: Multiple Choice

Which of the following statements moves the Members table from the dbo schema to the OurApp schema?

Answer:
1. 
alter schema [OurApp] move dbo.[Members] 
2. 
alter schema [OurApp] transfer dbo.[Members]
3. 
move dbo.[Members] to schema [OurApp] 
4. 
alter schema move dbo.[Members] to [OurApp]
5. 

None of the above.


 KB Article #102065 Counter
12477
Since 10/20/2009

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech