tags:

views:

24

answers:

0

I want a procedure that will create a table something like this...

call createTable("test.customers", 3);

It should generate the following create table statement.

create table test.customers(
  column1 varchar(1000), 
  column2 varchar(1000), 
  column3 varchar(1000)
);

In other words, a table name and the number of columns will be supplied and a create table statement will be returned.