select * from Metadata where Available='N'
--delete from Metadata where Available='N'

select * from MetaDataBinMap where (MetaDataId is not null) AND  (MetaDataId not in (select FieldKey from MetaData))
select * from MetaDataDrillThruSetColumn where (MetaDataId is not null) AND (MetaDataId not in (select FieldKey from MetaData))
select * from MetaDataField  where (FieldKey is not null) AND  (FieldKey not in (select FieldKey from MetaData))
--select * from MetaDataValue where (MetaDataId is not null) AND  (MetaDataId not in (select FieldKey from MetaData))

--delete from MetaDataBinMap where (MetaDataId is not null) AND  (MetaDataId not in (select FieldKey from MetaData))
--delete from MetaDataDrillThruSetColumn where (MetaDataId is not null) AND (MetaDataId not in (select FieldKey from MetaData))
--delete  from MetaDataField  where (FieldKey is not null) AND  (FieldKey not in (select FieldKey from MetaData))