using System;

public class Program

{

    public static void Main()

    {

        /*

--修正有一個欄位沒名稱,沒名稱不能用with as 

--下面才能再查詢

with tmp as (

Select nc.TABLE_SCHEMA, nc.TABLE_NAME, nc.COLUMN_NAME, nc.ORDINAL_POSITION, nc.IS_NULLABLE, IIF(nc.IS_NULLABLE <> oc.IS_NULLABLE, 'Yes', 'No')[nullable], 

        IIF(oc.COLUMN_NAME IS NULL, convert(varchar(20), 'ADDED COLUMN'), convert(varchar(20), '--')) as Comment

    from dev_Rota.INFORMATION_SCHEMA.COLUMNS nc

        LEFT join Rota.INFORMATION_SCHEMA.COLUMNS oc 

            on nc.TABLE_NAME = oc.TABLE_NAME and nc.COLUMN_NAME = oc.COLUMN_NAME

UNION ALL

    Select oc.TABLE_SCHEMA, oc.TABLE_NAME, oc.COLUMN_NAME, oc.ORDINAL_POSITION, oc.IS_NULLABLE, 'No', 'DELETED COLUMN' as Comment

    from Rota.INFORMATION_SCHEMA.COLUMNS oc

    where CONCAT(oc.TABLE_NAME, '.', oc.COLUMN_NAME) 

        not in (Select CONCAT(TABLE_NAME, '.', COLUMN_NAME) from dev_Rota.INFORMATION_SCHEMA.COLUMNS)

)

select distinct(TABLE_NAME), count(*) from tmp

group by TABLE_NAME

order by count(*) desc

*/

        Console.WriteLine("Hello World");

    }

}