Skip Navigation Links
Home
Forum Home
Latest 50
Unanswered
All Time Leaders
Jump to CategoryExpand Jump to Category
Login 
    Welcome Guest!
 Search Forum For :  
X
 Login
Please login to submit a new post, reply and edit exiting posts, see user profiles, and access more features. If you are not a registered member, Register here.
User Id / Email:
Password:  
Forgot Password | Forgot UserName
   Home » SQL Server » hide a particular table name of our schema
       
Author Reply
Alec Stewart
posted 59 posts
since Nov 03, 2011 
from

 hide a particular table name of our schema
  Posted on: 01 Feb 2012       
Can i hide a particular table name of our schema if yes then how?
Sponsored by
Mike Starc
posted  65 posts
since  Dec 05, 2011 
from 

 Re: hide a particular table name of our schema
  Posted on: 02 Feb 2012   Accepted Answer     0  
Hi Alec,
We can create in two ways:
1) using synonym
2) by using views.
if you swicth to another user we have to specify user name with view. in case of synonym we dont need to specify user name, directly we can use
Alec Stewart
posted  59 posts
since  Nov 03, 2011 
from 

 Re: hide a particular table name of our schema
  Posted on: 07 Feb 2012        0  
Thanku very much Mike.
       

 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Site Map  |  Advertise with us
Current Version: 5.2011.3.12
 © 1999 - 2012  Mindcracker LLC. All Rights Reserved