/SQL/Identify primary key in oracle table

Identify primary key in oracle table

-- 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;

Similar codes

0 vote338 views1 answer
Mysql show foreign keys column
SQL
0 vote399 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
8 votes369 views1 answer
Ltrim sql
SQL
4 votes344 views1 answer
Select nls_date_format
SQL
0 vote367 views1 answer
R write csv without index
SQL
0 vote386 views1 answer
Oracle current date minus 1 day
SQL
3 votes349 views2 answers
Mysql select database
SQL
0 vote308 views1 answer
FindAllBy
SQL
8 votes361 views1 answer
Sql limit results returned
SQL
1 vote368 views1 answer
Oracle grant on all tables in schema
SQL