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
« April 2024 »
April
MoTuWeThFrSaSu
1234567
891011121314
15161718192021
22232425262728
2930