Oracle - Create Table with Primary Key, Not Null and Foreign Key Constraints

Search Database SQL / Scripts

Help us in improving the repository. Add new Queries/Scripts through 'Submit Database SQL / Scripts ' link.

Submit SQL/Scripts

Database Queries/Scripts

Sample 1. Oracle - Create Table with Primary Key, Not Null and Foreign Key Constraints

CREATE TABLE TABLE_NAME (

  ID            NUMBER        CONSTRAINT ID_KEY PRIMARY KEY,

  NAME          VARCHAR(50)   CONSTRAINT NAME_NOT_NULL NOT NULL,

  CONSTRAINT NAME_FK FOREIGN KEY (NAME) REFERENCES OTHER_TABLE_NAME (NAME)

);

_{Like Feedback create table create table with foreign key}