assert_table_primary_key.sql

create or replace procedure f.assert_table_primary_key(table_name string, key_name string)
begin
  execute immediate '''
    with
      results as (
        select
          (select count(*) from ''' || table_name || ''') as cnt,
          (select count(distinct ''' || key_name || ''') from ''' || table_name || ''') as cnt_distinct,
      )
    select * from results
    where
      if(cnt = cnt_distinct, true, error(' ''' || table_name || '''.''' || key_name || ''' is not unique key. count: ' || cnt || ' . unique count: ' || cnt_distinct || '.')) 
  ''';
end;

-- call f.assert_table_primary_key('yoshioka_test1.tbl', 'id');