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.

Answers


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

Index Basics

Types of Indexes


Need Your Help

Javascript: List all variables in the same scope (iframe)

javascript iframe scope global-variables

I do have some custom code in an iframe, where I declare a global variable. Within the iframe there is also third party code, which globals I would like to access.

overwriting a method via stubbing with OCMock

objective-c ocunit ocmock

I am trying to test that a timer object is stopped after a level is completed.. I have the following code:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.