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
« February 2024 »
February
MoTuWeThFrSaSu
1234
567891011
12131415161718
19202122232425
26272829