Re: How can I quit this: "Unique " to my table?

On Tuesday 01 April 2003 21:26, Achilleus Mantzios wrote:
> On Tue, 1 Apr 2003, Luis Mix wrote:
> > Hello pgsql-sql,
> >
> > When my table was create I wrote this:
> >
> > MyDatabase=# create table b_prestamo(no_inventa char(16) unique not
> > null, cve_area char(10), date1 date);
> > I need now that my table can accept repeated records, but not Null.
> > How can I do that?
> > SomeBody can help me please?
> > My table has information at the moment,what can I do for maintain
> > it?
>
> drop index b_prestamo_no_inventa_idx;

ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key ??

Ian Barwick
barwick(at)gmx(dot)net