\d <schema_name>.<table_name> will show you columns, their types and the
modifiers. If you look in the modifiers section, you will be able to see
existing sequences.
Payal Singh,
OmniTi Computer Consulting Inc.
Junior Database Architect,
Phone: 240.646.0770 x 253
On Fri, Nov 15, 2013 at 2:30 PM, Thara Vadakkeveedu <tharagv(at)yahoo(dot)com>wrote:
> How can we find out if a particular sequence exists ? The idea is to check
> if sequence first and if it does not exist then create it...the goal is to
> do this when we deploy the application war...
> thanks
> tg
>
>
>