Friday, June 3, 2016

Find Column Mismatch in Different Database

//Except
//Table1 Not Mactch Value Display

SELECT TABLE_NAME,COLUMN_NAME

FROM GCLV.INFORMATION_SCHEMA.COLUMNS a

except

SELECT TABLE_NAME,COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS a

No comments: