What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-03 12:05:44
oracle list 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.... Add solution -
SQL 2021-10-29 21:06:11
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.... Add solution