dynamic table creaton

[BalaQT]

hi balu,

May be I will have to go with the both date and time.

yeah table with Datetime will be a good idea,

or u can create log table which stores all the table creation details and u can take the id from the log table.
ex:
DynamicLog(tabid int,timestamp datetime,userid int);
for the first time , this table will be empty. and when the user logs in, say tabel name 1 is created with the values inserted into the DynamicLog(1,time,userid);
then when the user again logs in , take DynamicLog's max(tabid)+1 and create the table with that id

hope it helps
Bala