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 vote247 views2 answers
Sql update top 100
SQL
0 vote280 views2 answers
Sql auto update dupdated_at
SQL
0 vote265 views1 answer
Sql examples from framework
SQL
0 vote264 views1 answer
Oracle select partition
SQL
0 vote282 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
3 votes260 views2 answers
Oracle apex view logs
SQL
1 vote251 views1 answer
Real world example of nosql
SQL
-1 vote260 views5 answers
Online sql to linq generator
SQL
1 vote259 views3 answers
How to truncate foreign key constraint table
SQL
3 votes258 views2 answers
How to start postgresql on windows
SQL