Personal tools
You are here: Home → Les outils logiciels → SGBD → Oracle → Oracle : sql - show all constraint
Log in


Forgot your password?
 

Oracle : sql - show all constraint

sql : show all constraint

select * 
from all_constraints
where constraint_name = 'SYS_C0021041';

sql : show all constraint of a table

SELECT constraint_name, constraint_type, column_name
from user_constraints natural join user_cons_columns
where table_name = 'ARRIVAL_NOTIFICATION';

 

Document Actions
« March 2024 »
March
MoTuWeThFrSaSu
123
45678910
11121314151617
18192021222324
25262728293031