/TypeScript/How to check constraints on a table in sql oracle

How to check constraints on a table in sql oracle

How to find constraints on a table in oracle

SELECT cons.OWNER 			AS CHILD_OWNER,
       cons.TABLE_NAME 		AS CHILD_TABLE,
       cons.CONSTRAINT_NAME AS CONSTAINT_NAME,
       cons.CONSTRAINT_TYPE AS CONSTRAINT_TYPE,
       col.OWNER 			AS PARENT_OWNER,
       col.TABLE_NAME 		AS PARENT_TABLE,
       col.COLUMN_NAME 		AS COLUMN_NAME
FROM DBA_CONS_COLUMNS col, DBA_CONSTRAINTS cons
WHERE cons.R_OWNER = col.OWNER
  AND cons.R_CONSTRAINT_NAME = col.CONSTRAINT_NAME
  AND cons.TABLE_NAME = 'table_name';

Source: dba-oracle.com

How to check constraints on a table in sql oracle

SELECT *
  FROM user_cons_columns
 WHERE table_name = '<your table name>';

Source: stackoverflow.com

Similar codes

0 vote282 views2 answers
Use toasts in django
TypeScript
2 votes260 views1 answer
Mat-form-field email validation
TypeScript
6 votes256 views1 answer
Comments pycharm
TypeScript
2 votes280 views3 answers
Jquery don't empty specific form field after submit
TypeScript
0 vote276 views1 answer
Error: running homebrew as root is extremely dangerous and no longer supported. as homebrew does not drop privileges on installation you would be giving all build scripts full access to your system.
TypeScript
1 vote276 views1 answer
Unity lists number of
TypeScript
0 vote296 views1 answer
What kind of projects is suitable for the Agile methodology
TypeScript
1 vote300 views1 answer
Whats the file path for the documents folder linux
TypeScript
0 vote272 views1 answer
Uat testing vs system testing
TypeScript
8 votes268 views3 answers
Update local angular cli
TypeScript