SQL> select table_name from dba_constraints where constraint_name='SMCCLIENTINFO_MISSINGHQ';
TABLE_NAME
--------------------------------------------------------------------------------
SMCLIENTINFO
SQL> select dbms_lob.substr((SELECT DBMS_METADATA.GET_DDL('TABLE','SMCLIENTINFO','SUPERMAG') from dual),4000,1) from dual;
....
CONSTRAINT "SMCCLIENTINFO_MISSINGHQ" FOREIGN KEY ("HEADQUARTERS")
REFERENCES "SUPERMAG"."SMCLIENTINFO" ("ID") ENABLE,
....
select * from "SUPERMAG"."SMCLIENTINFO"
select * from "SUPERMAG"."SMCLIENTINFO"