Re: checking if sequence exists

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



\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@xxxxxxxxx> 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

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux