Breaking News: Grepper is joining You.com. Read the official announcement!

oracle create table primary key

Misty Marten answered on June 15, 2021 Popularity 9/10 Helpfulness 5/10

answer oracle create table primary key

related identify primary key in oracle table

oracle create table primary key

Comment

CREATE TABLE table_name
(
  column1 datatype null/not null,
  column2 datatype null/not null,
  ...
  CONSTRAINT constraint_name PRIMARY KEY (column1, column2, ... column_n)
);

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: create-table oracle primary-key sql

Link to this answer
Share Copy Link

Contributed on Jun 15 2021

Misty Marten

0 Answers Avg Quality 2/10

Closely Related Answers

identify primary key in oracle table

Comment

-- Primary key in a table
SELECT * FROM ALL_CONSTRAINTS 		-- or DBA_CONSTRAINTS or UESR_CONSTRAINTS
WHERE TABLE_NAME= 'table_name' AND CONSTRAINT_TYPE = 'P';
-- With columns names:
SELECT c.OWNER, c.TABLE_NAME, c.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, 
	col.COLUMN_NAME
FROM ALL_CONSTRAINTS c
JOIN ALL_CONS_COLUMNS col ON c.TABLE_NAME = col.TABLE_NAME 
    AND c.CONSTRAINT_NAME = col.CONSTRAINT_NAME
WHERE c.TABLE_NAME= 'table_name' AND c.CONSTRAINT_TYPE = 'P'
ORDER BY c.TABLE_NAME, c.CONSTRAINT_NAME, col.COLUMN_NAME;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: identify identif

Link to this answer
Share Copy Link

Contributed on Jul 03 2021

VasteMonde

0 Answers Avg Quality 2/10

oracle create table primary key

Contents

More Related Answers

oracle create table primary key

Closely Related Answers

identify primary key in oracle table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.