See if this helps...
declare @datatype1 varchar(50)
declare @datatype2 varchar(50)
SELECT @datatype1 = DATA_TYPE
FROM information_schema.columns
WHERE table_schema = 'dbo'
AND table_name = 'Table_1'
AND column_name = 'AreaID' ;
SELECT @datatype2 = DATA_TYPE
FROM information_schema.columns
WHERE table_schema = 'dbo'
AND table_name = 'Table_2'
AND column_name = 'AreaID' ;
select 'true' where @datatype1 = @datatype2