ProgrammingOcean

SELECT sysobjects.name FROM syscolumnsleft join sysobjects on sysobjects.id = syscolumns.id WHERE syscolumns.name like 'OBRNo'

SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE UPPER( COLUMN_NAME ) LIKE '%FRANCE%';