Re: 7.4 - TODO : alter table drop foreign key
От | Christopher Kings-Lynne |
---|---|
Тема | Re: 7.4 - TODO : alter table drop foreign key |
Дата | |
Msg-id | 01ff01c29c9a$29f7d680$6500a8c0@internal обсуждение исходный текст |
Ответ на | Re: 7.4 - TODO : alter table drop foreign key ("Dan Langille" <dan@langille.org>) |
Ответы |
Re: 7.4 - TODO : alter table drop foreign key
|
Список | pgsql-hackers |
> > Isn't it identical? The CONSTRAINT <const> is SQL standard optional clause > > for all commands that add constraints. > > Except that one is ADD CONSTRAINT, the other is an ADD FOREIGN KEY. > They are similar in nature but different overall. I think you're getting a little confused here, Dan. http://www3.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-altertable. html There is only one command for adding constraints to a table. It has this syntax: ALTER TABLE [ ONLY ] table [ * ] ADD table_constraint The table_constraint clause is defined like this (basically): [CONSTRAINT blah] (PRIMARY KEY or UNIQUE or FOREIGN KEY) ... So, the CONSTRAINT blah clause allows you to specify a name for any of the 3 types of constraint: primary key, unique or foreign key. There's nothing special about foreign keys in this case. If you don't put in the CONSTRAINT blah clause, you get an automatically assigned constraint name. Chris
В списке pgsql-hackers по дате отправления: