/* @infoBD_UZ.sql */

SET linesize 80
SET pagesize 128
SET echo ON

column Nombre            heading "columna"       format a30;

/* mostrar la información básica de las tablas y vistas
*/
SELECT * FROM CAT;
DESCRIBE Departamento;
DESCRIBE AreaConoc;
DESCRIBE Profesor;
DESCRIBE Asignatura;
DESCRIBE Titulacion;
DESCRIBE ImparteAsign;
DESCRIBE AsignTitulo;

DESCRIBE user_constraints;

column OWNER             heading "dueño"         format a10;
column TABLE_NAME        heading "tabla"         format a14;
column CONSTRAINT_NAME   heading "namRestric"    format a16;
column SEARCH_CONDITION  heading "cond.busq."    format a24;
column R_OWNER           heading "dueñoRef"      format a10;
column R_CONSTRAINT_NAME heading "namRestricRef" format a16;

SET linesize 255

SELECT * 
 FROM user_constraints
 WHERE INITCAP(table_name) IN ('Departamento', 'Areaconoc', 'Profesor', 'Asignatura',
                               'Titulacion', 'Imparteasign', 'Asigntitulo');
SET linesize 80