sql compare tables for differences

1(SELECT * FROM T1 MINUS SELECT * FROM T2)   -- Rows that are in T1 but not in T2
2UNION ALL
3(SELECT * FROM T2 MINUS SELECT * FROM T1);  -- Rows that are in T2 but not in T1

1-- Find the different tables and columns between DB_NBR_1 and DB_NBR_2
2-- (just replace DB_NBR_1 and DB_NBR_2)
3select isnull(db1.table_name, db2.table_name) as [table],
4       isnull(db1.column_name, db2.column_name) as [column],
5       db1.column_name as scripts_col_name
6      ,db1.column_type as scripts_col_type
7       ,db1.column_precision as scripts_col_precision
8
9      ,db2.column_name as liquid_col_name
10      ,db2.column_type as liquid_col_type
11      ,db2.column_precision as liquid_col_precision
12from
13(select schema_name(tab.schema_id) + '.' + tab.name as table_name, 
14       col.name as column_name
15      ,y.name as column_type
16      ,y.precision as column_precision
17   from [DB_NBR_1].sys.tables as tab
18        inner join [DB_NBR_1].sys.columns as col
19            on tab.object_id = col.object_id
20         JOIN sys.types y ON y.user_type_id = col.user_type_id
21         ) db1
22full outer join
23(select schema_name(tab.schema_id) + '.' + tab.name as table_name, 
24       col.name as column_name
25      ,y.name as column_type
26      ,y.precision as column_precision
27   from [DB_NBR_2].sys.tables as tab
28        inner join [DB_NBR_2].sys.columns as col
29            on tab.object_id = col.object_id
30         JOIN sys.types y ON y.user_type_id = col.user_type_id
31         ) db2
32on db1.table_name = db2.table_name
33and db1.column_name = db2.column_name
34where (db1.column_name is null or db2.column_name is null)
35order by 1, 2, 3
36