how to check constraints on a table in sql oracle
SELECT *
FROM user_cons_columns
WHERE table_name = '<your table name>';how to check constraints on a table in sql oracle
SELECT *
FROM user_cons_columns
WHERE table_name = '<your table name>';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';Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
