Adding constraints (FOREIGN KEY) to a table : FOREIGN KEY « Constraints « PostgreSQL

PostgreSQL 1.  Aggregate Functions 2.  Analytical Functions 3.  Array 4.  Constraints 5.  Cursor 6.  Data Type 7.  Database 8.  Date Timezone 9.  Index 10.  Inheritance 11.  Insert Delete Update 12.  Math Functions 13.  Postgre SQL 14.  Select Query 15.  Sequence 16.  Store Procedure Function 17.  String Functions 18.  Subquery 19.  Table 20.  Table Joins 21.  Transaction 22.  User Previliege 23.  View Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

PostgreSQL » Constraints » FOREIGN KEY   Adding constraints (FOREIGN KEY) to a table postgres=# postgres=# postgres=# -- Creating the books table postgres=# postgres=# CREATE TABLE books ( postgres(#               id integer UNIQUE, postgres(#               title text NOT NULL, postgres(#               author_id  integer, postgres(#               subject_id integer, postgres(#               CONSTRAINT books_id_pkey PRIMARY KEY (id)); ERROR:  relation "books" already exists postgres=# postgres=# create table editions ( postgres(#              edition_id integer, postgres(#              book_id    integer postgres(#              ); CREATE TABLE postgres=# postgres=# postgres=# -- Adding constraints to a table postgres=# postgres=# ALTER TABLE editions postgres-#                  ADD CONSTRAINT foreign_book postgres-#                  FOREIGN KEY (book_id) REFERENCES books (id); ALTER TABLE postgres=# postgres=# drop table books cascade; NOTICE:  drop cascades to constraint foreign_book on table editions DROP TABLE postgres=# postgres=# drop table editions cascade; DROP TABLE postgres=#                     Related examples in the same category 1.  Define foreign key for a table 2.  Reference two two columns as foreign key column 3.  Adding a constraint to an existing table: add foreign key to table 4.  Create FOREIGN KEY 5.  Using foreign keys 6.  ALTER TABLE employee ADD FOREIGN KEY (group_id) REFERENCES product_groups

www.java2java.com | Contact Us

Copyright 2010 - 2030 Java Source and Support. All rights reserved.

All other trademarks are property of their respective owners.