Oracle desc table primary key

-- 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 vote103 views1 answer
Pip install mysqlclient error
SQL
0 vote106 views7 answers
10 random questions use python and SQL
SQL
3 votes105 views2 answers
Oracle for loop
SQL
0 vote164 views1 answer
TSQL Find csv file in folder
SQL
0 vote99 views1 answer
Postgres add prefix to primary key
SQL
24 votes106 views4 answers
Postgres delete database
SQL
3 votes112 views1 answer
Select database in sql
SQL
0 vote122 views1 answer
Including parameters in OPENQUERY
SQL
22 votes113 views3 answers
Remove all records from table mysql
SQL
22 votes111 views3 answers
How to join three tables in sql using joins
SQL