Is it possible to rename table to datetime?

[Newb Mac]

is it possible to rename table to datetime?
if yes, can anyone show me how?
thanks..

[somdutt]

Yes, it can be done.

I assume your table name as mytable1 -

create table [mytable1] ( id int )
go

declare @stmt varchar(100)
declare @old_name sysname , @new_name sysname

set @old_name = 'mytable1'
select @new_name=repla ce(replace(repl ace ( replace(convert (varchar, getdate() ,121) ,' ', '_'),'-', '_') ,':', '_'),'.','_')


set @stmt='exec sp_rename ''' + @old_name + ''', ''' + @new_name + ''''
print 'Executing Statement - ' + @stmt

exec (@stmt)

[Newb Mac]

i found the way already..Thanks ..