Home » SQL & PL/SQL » SQL & PL/SQL » constraints (sql command line)
constraints [message #601774] Mon, 25 November 2013 10:14 Go to next message
aravindreddy.akiti
Messages: 14
Registered: October 2013
Location: hyderabad
Junior Member
how to define column level Primary and Foreign Keys in sql.
Re: constraints [message #601775 is a reply to message #601774] Mon, 25 November 2013 10:18 Go to previous messageGo to next message
BlackSwan
Messages: 22926
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual yourself

http://docs.oracle.com/cd/E16655_01/server.121/e15858/toc.htm

CREATE TABLE
or
ALTER TABLE
statements can be used to establish PRIMARY & FOREIGN KEYS
Re: constraints [message #601776 is a reply to message #601774] Mon, 25 November 2013 10:19 Go to previous message
ThomasG
Messages: 3103
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
With the Constraint Clauses of Alter Table for example.
Previous Topic: DBMS_LDAP Search filter
Next Topic: unix time to date
Goto Forum:
  


Current Time: Fri Oct 31 05:00:00 CDT 2014

Total time taken to generate the page: 0.10027 seconds