create procedure sp_addtid2InvTables
as
begin
/*}*/

    declare @tntree varchar(64);
    declare @tnitem varchar(64);
    declare @tblowner nvarchar(255);

    DECLARE mycur CURSOR local
        FOR select table_name_tree, table_name_item, tbl_owner from inv_table_map;
        
    declare @updSql varchar(255);    
    

    OPEN mycur
    FETCH NEXT FROM mycur INTO @tntree, @tnitem, @tblowner; -- get first
    WHILE @@FETCH_STATUS = 0
    BEGIN
                
        if( @tblowner = 'ca_itrm')
        begin -- prefix table name
        
            execute ('alter table ' + @tblowner + '.' + @tntree  
                + '    add tenant_id binary(16)')

            execute ('alter table ' + @tblowner + '.' + @tnitem  
                + '    add tenant_id binary(16)')

        end;
        
        FETCH NEXT FROM mycur INTO @tntree, @tnitem, @tblowner; -- get next

    END

    CLOSE mycur
    DEALLOCATE mycur


end;
GO
GRANT EXECUTE ON  [dbo].[sp_addtid2InvTables] TO [ca_itrm_group]
GO