Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to drop a foreign key in a table ???

Status
Not open for further replies.

totti24

Programmer
Aug 2, 2002
32
MY


i would like to know how to drop a foreign key from a table in postgresql????
 
you need to know the name of the index
and then write
drop index indexname
if you are using phpPgAdmin there will be a link to the list of all indexes
otherwise in the console
type \?
this will list all the options for lists
e.g. \df gives a list of functions and so on
choose the command to list indexes and then
type
drop index indexname
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top