The main question is why you creating table from application I do not think it is good idea...
If all table you planning to create has the same structure, why not use the one table for all of them?
just create table with right indexes as on example below
and you never need to use INFORMATION_SCHEMA table....
create table yourTableName
[name] varchar(10) not null,
amount varchar(6), not null default '0',
[userTableName] varchar(20) not null,
PRIMARY KEY ( [userTableName], [name] )
select sum(amount), userTableName
group by userTableName