Selective columns for creating synonym

Hi, I wanted to create a synonym only for specfic columns from a table. Is it possible..? Thanks Krishnan

Krishnan, First create a view that fulfills your column requirements and then create a synonym to the view. Use the CREATE SYNONYM statement to declare and register an alternative name for an existing table, view, or sequence object. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KRISHNAN BALASUBRAMANIAN Sent: Thursday, December 25, 2008 11:58 PM To: ids@iiug.org Subject: Selective columns for creating synonym [14402] Hi, I wanted to create a synonym only for specfic columns from a table. Is it possible..? Thanks Krishnan ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

No. Use a VIEW. Art On Fri, Dec 26, 2008 at 12:57 AM, KRISHNAN BALASUBRAMANIAN < krishnanbalasubramanian@rediffmail.com> wrote: > Hi, > > I wanted to create a synonym only for specfic columns from a table. Is it > possible..? > > Thanks > Krishnan > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Thanks Joe. Krishnan

Thanks Art. Krishnan