Your selected language is
US English
Home
Forum Home
Latest 50
Unanswered
All Time Leaders
Jump to Category
Adabas
Backup & Recovery
Berkeley
Btrieve
Crystal Reports
Data Modeling
Data Warehousing
Database FAQ
Database Tools
DB Administration
DB2
Gupta Database
Ingress
Installations
Microsoft Access
Microsoft Office
MySQL
OLAP
Oracle
Paradox
Performance & Tuning
PL/SQL
PostgreSQL
Security
SQL Reporting Services
SQL Server
Sybase
T-SQL
XBase
Login
Welcome
Guest!
Search Forum For :
All
Database
Any Word
Exact Word
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:
Remember Me
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.
Quick Reply:
Sponsored by
Become a Sponsor
Our recommended articles
How to Rename a table name or column name in SQL Server 2008.
How to get all the table names which contains the same column name in SQL Server
Rename a column name and table name in Database
Correlation names or table alias
Creating Schema Binding View in SQL Server
Schema in SQL Server
Named Parameters in SQLite
How to Rename a Column Name or Table Name.
How to create service naming in Oracle
SQL Update Command
Our recommended forum posts
Data from two different Table from different type of Database
Inline Table-Valued Function
Retrieve data from two or more table in SQL Server
CSV tables
Cobol file in DB2
Find out the Middle Row of Employee Table ?
Test Table in MySQL server
MyISAM table in MySQL
Creation of table in PL/SQL
Execution of data in SQL
Latest
Articles
Understanding DataTypes in MySql
Use of Having clause in MySql
Concept of composite key in MySql
Concepts of Aggregate functions in SQL Server
Concepts of Inner Join, Outer Join, Cross Join And Self Join in SQL Server
To make the column value unique in MySql
Concepts of Search in Stored Procedure With Dynamic Query in SQL Server
How to copy an existing MySql table to a new table with same architecture
Use of Wildcards in MySql
Working with NULL values in MySql
View all »
Latest
News
Oracle #1 Database
Download Microsoft SQL Server 2012 Feature Pack
Samsung overtakes Nokia as top mobile maker
Oracle Buys ClearTrial
Google launches monthly user activity feature
View all »
Latest
Blogs
LAG and LEAD in SQL Server 2012
How to create sequence in pl/sql
Inbuilt Functions
Description of operators in MySQL
What is the difference between Delete, Truncate and Drop in Oracle
NVL Function in Oracle/PLSQL
Ingmon in Ingres
Normalization in Database
Join Operator in MYSQL
Inbuilt functions in SQL
View all »
Top
Articles
Concept of cursor in SQL Server
New Features of SQL Server 2012
Encryption and Decryption of Word Document
Integrated Enterprise Data Warehouse
Adding a Language to MS Word
Concept of Views in Database
Automatic Text Correction in MS Word
PL/SQL FAQ'S
Setting the Privacy Priorities in the MS Word
Concept of Multi-statement table value function in SQL Server
View all »
Free
Book Chapters
Getting Your Tools
Chapter 3: How to retrieve data from a single table
Chapter 1: SQL Query Performance Tuning
View all »
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
Channels
:
Jobs
|
Interviews
|
Consulting
|
Photos
|
Authors
|
Tips
Programming
:
C#
|
Visual Basic
|
ASP.NET & Web Development
|
C++
|
Other .NET Languages
|
Windows Vista
|
XAML
|
Tutorials
Sponsors
: