If the constraint were named then it could be dropped - another good
reason to name all constraints. I like Oracle Designer's way of
applying the constraints with ALTER TABLE rather than CREATE TABLE -
maintenance is much easier.
> I presume you want to remove the unique column constraint?
>
> The ALTER TABLE command doesn't allow you to do this so another way
> is as follows:
...
>
> If you have any reference or foreign key constraints that refer to
> the b_prestamo table, then you will need to drop those constraints
> and add them back after changing the table.
>
> Regards,
> David Witham
> Telephony Platforms Architect
> Unidial
>
> -----Original Message-----
> From: Luis Mix [mailto:ksql2002@yahoo.com.mx]
> Sent: Wednesday, 2 April 2003 00:35
> To: pgsql-sql@postgresql.org
> Subject: [SQL] How can I quit this: "Unique " to my table?
>
>
> 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?
>
>
>
> --
> Best regards,
> Luis mailto:ksql2002@yahoo.com.mx
>
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://platinum.yahoo.com