Idea's to Create a table dynamically
Is it possible to create a table in SQL dynamically. In my web application I need to store the data in a table named as "INFO_2013" for this year (i.e) 2013. When the system date changes to 2014, then a new table has to be created as "INFO_2014" and the values have to be added in that table.
NOTE : Also the Table has to be in the same DB.
I would avoid using this approach.
Why not rather create a single table, with a YEAR column, which will identify which year it is from?
Further to that, if you are woried about the table getting to large, you might want to take a look at Creating Partitioned Tables and Indexes
May have a look at these too