Categorias
iiiiii
ORACLE DATABASE CURSE
Descripcion
ver el campo establecido como clave primaria de un
Scrippt
select uc.table_name,
column_name
from user_cons_columns ucc
join user_constraints uc
on ucc.constraint_name=uc.constraint_name
where uc.constraint_type = 'P' and
uc.table_name = 'USUARIOS';
Plsql
select uc.table_name,
column_name
from user_cons_columns ucc
join user_constraints uc
on ucc.constraint_name=uc.constraint_name
where uc.constraint_type = 'P' and
uc.table_name = 'USUARIOS';