John R Pierce <pierce(at)hogranch(dot)com> writes:
> On 11/5/2015 11:25 PM, Thomas Kellerer wrote:
>> But having an "alter table drop primary key" would indeed be nice.
> is that syntax in the sql standard? or is it just an oraclism?
AFAICS there is no such syntax in SQL:2011 --- it only offers
"ALTER TABLE name DROP CONSTRAINT name".
regards, tom lane