From: | William Diaz Pabón <widipa(at)hotmail(dot)com> |
---|---|
To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Modificar el nombre de la constaint de una primary key |
Date: | 2008-04-04 15:11:34 |
Message-ID: | BAY139-W3890C394213EE1ACBE54C1CDF60@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola a todos.
Tengo una tabla asi:
CREATE TABLE curso_area( curso_sede numeric(30) NOT NULL, area character varying(4) NOT NULL, CONSTRAINT "Key1" PRIMARY KEY (curso_sede, area), CONSTRAINT curso_area_area_fk FOREIGN KEY (area) REFERENCES area (codigo) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT curso_area_curso_sede_fk FOREIGN KEY (curso_sede) REFERENCES curso_sede (consecutivo) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION)WITH (OIDS=FALSE);ALTER TABLE curso_area OWNER TO colegio;
pero quiero cambiar el nombre de la constraint "Key1", por le nombre curso_area_pk. Como puedo hacerlo si ya existen relaciones de esa tabla con otras?
Cordialmente. William Diaz Pabón Ing. de SistemasSoluciones Empresariales.Cel: 3173314172 - 3156396316Tunja - Boyacá - Colombia
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
From | Date | Subject | |
---|---|---|---|
Next Message | Gilberto Castillo Martínez | 2008-04-04 15:46:39 | Re: Usuarios dinamicos |
Previous Message | Sonia Perez Peña | 2008-04-04 14:58:03 | RV: instalacion del PHPPGADMIN |