Selective columns for creating synonym

Posted in 2008

Summary

Krishnan Balasubramanian asked whether a synonym can be created for only specific columns of a table. Joe Plugge and Art Kagel both answered that it cannot, and advised creating a VIEW with the needed columns, optionally with a synonym on the view. Krishnan thanked both.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

KRISHNAN BALASUBRAMANIAN — Fri, 26 Dec 2008 05:57:50 — source: IIUG Forums & Mailing Lists

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

↪ replying to KRISHNAN BALASUBRAMANIAN

Plugge, Joe R. — Fri, 26 Dec 2008 14:36:23 — source: IIUG Forums & Mailing Lists

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.

↪ replying to KRISHNAN BALASUBRAMANIAN

Art Kagel — Fri, 26 Dec 2008 20:17:32 — source: IIUG Forums & Mailing Lists

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.

↪ replying to Plugge, Joe R.

KRISHNAN — Mon, 29 Dec 2008 04:27:18 — source: IIUG Forums & Mailing Lists

Thanks Joe. Krishnan

↪ replying to Art Kagel

KRISHNAN — Mon, 29 Dec 2008 04:29:11 — source: IIUG Forums & Mailing Lists

Thanks Art. Krishnan