csql = "declare @count int = 0; " +
                   "if (object_id(N'dbo.[" + typename + "]', N'table') is not null) " +
                   "begin" +
                   "  drop table dbo.[" + typename + "]; " +
                   "end; " +
                   "select @count = object_id from sys.objects where type='TT' and name LIKE N'%TT[_]" + typename + "[_]%'; " +
                   "if (@count <> 0) " +
                   "begin" +
                   "  drop type dbo.[" + typename + "]; " +
                   "end;";

do $$ 
declare 
   typename text := 'Шпана'; 
   typeid text := '9f9bde87-6873-43c3-9508-9c6d86efb3ff'; 
   count bigint := 0; selstr text := ''; 
begin 
  select count(*) into count 
  from "ТипСсылкаНаТип"
  where "ТипИД" = cast(typeid as uuid) and 
        "Наименование" <> 'РодительИД' and 
        "Ограничение целостности" = true; 
  if (count > 0) 
  then  
    select selstr || 'Alter table "' || typename  ||   '" Add constraint "' || typename || '_' ||
                     ("Тип"."Наименование") || '{' || "ТипСсылкаНаТип"."Наименование" || '}' ||
                     '" foreign key ("' || "ТипСсылкаНаТип"."Наименование" || '") references "' ||   
                     ("Тип"."Наименование") || '"("ИД") ON DELETE' || 
                     case when "ТипСсылкаНаТип"."Правила удаления" = 'SetNull' then 'SET NULL' 
                     else 'NO ACTION' end || '; '  
    into selstr  
    from "ТипСсылкаНаТип"  
    join "Тип" on "Тип"."ИД" = "ТипСсылкаНаТип"."СсылкаНаТипИД"   
    where "ТипИД" = cast(typeid as uuid) and 
          "ТипСсылкаНаТип"."Наименование" <> 'РодительИД' and 
          "ТипСсылкаНаТип"."Ограничение целостности" = true; 
   end if; 
   select count(*) into count 
   from "ТипОграничение" 
   where "ТипИД" = cast(typeid as uuid) and 
         "Тип ограничения" = 'foreign key'
   if (count > 0) 
   then   
     select cast(selstr as text) || 'Alter table "' || typename || '" Add foreign key (' || 
                                    "Выражение" || ')'
     into selstr from "ТипОграничение" 
     where "ТипИД" = cast(typeid as uuid) and 
           "Тип ограничения" = 'foreign key'; 
   end if; 
   if (selstr <> '') 
   then   
     perform selstr; 
   end if; 
end; $$

do $$
declare selstr text = '';
begin
Select selstr || "Тип"."Наименование" into selstr from "Тип";
raise notice '%', selstr;
end; $$

 case "Npgsql":
                    csql = "do $$ " +
                           "declare " +
                           "typename text := '" + typename + "'; " +
                           "r record; " +
                           "selstr text := ''; " +
                           "begin " +
                           "  for r in " +
                           "    select conname " +
                           "    from pg_constraint a, pg_class b " +
                           "    where b.relkind = 'r' and " +
                           "    b.relname = 'Вася' and " +
                           "    a.contype = 'f' and " +
                           "    a.conrelid = b.oid) " +
                           "  loop " +
                           "    select selstr || 'Alter table [' || typename  || '] drop constraint [' + r.conname || '] ' into selstr; " +
                           "  end loop; " +
                           "  if (selstr <> '')" +
                           "  then " +
                           "    execute selstr;" +
                           "  end if;" +
                           "end; $$";
                    csql = ConvertCommandTextToNeutralFormat(csql);

do $$ 
declare   
   collist text  = '';   
   old text := 'wwwww';   
   new text := 'wwwww';   
   r record
begin   
  drop table if exist older;   
  select * into older from old;   
  do $$ 
  declare 
    typename text := 'wwwww'; 
    r record; selstr text := ''; 
    begin  
      for r in     
        select conname     
        from pg_constraint a, pg_class b     
        where b.relkind = 'r' and     
              b.relname = typename and     
              a.contype = 'f' and     
              a.confrelid = b.oid   
      loop 
        select selstr || 'Alter table "' || typename  || '" drop constraint "' + r.conname || '" ' 
        into selstr;   
      end loop;   
      if (selstr <> '')  
      then 
        execute selstr;  
      end i
  end; $$  
  do && 
  begin  
    drop table if exist wwwww;   
    drop type if exist wwwww; 
  end; $$  
  do $$ 
  begin  
    Create table "wwwww" ("ИД" UUID not null primary key,"ТипИД" UUID not null,"Иван" UUID null); 
  end;$$  
  for r in      
    select attname        
    from pg_attribute a, pg_class c, pg_class cc, pg_attribute aa      
    where c.relname = old and            
          cc.relname = new and            
          a.attrelid = c.oid and            
          aa.attrelid = cc.oid and            
          a.attname = aa.attname   
  loop     
    select collist || '[' || r.attname || '], ' 
    into collist;   
  end loop;   
  select collist := substring(collist, 1, len(collist) - 1);   
  exec ('insert ' || new || '(' || collist || ') select ' || collist || ' from older');   
  drop table if exist older; 
end; $$