Hi All,
I have a .mdb file which has about 20 tables in which I need to rename the latest created table.
Now to identify the latest created table I am using the below query:
SELECT a.Name, a.ID, a.DateCreate
FROM MSysObjects AS a INNER JOIN (SELECT Max( DateCreate) as Latest
FROM MSysObjects
Where Flags = 0) AS b ON a.DateCreate = b.Latest;
which is successful but I am unable to rename the table as 'TableName_mm/dd/yyyy' through SQL.
Request for advise/help.
Thanks,
Rakesh
I have a .mdb file which has about 20 tables in which I need to rename the latest created table.
Now to identify the latest created table I am using the below query:
SELECT a.Name, a.ID, a.DateCreate
FROM MSysObjects AS a INNER JOIN (SELECT Max( DateCreate) as Latest
FROM MSysObjects
Where Flags = 0) AS b ON a.DateCreate = b.Latest;
which is successful but I am unable to rename the table as 'TableName_mm/dd/yyyy' through SQL.
Request for advise/help.
Thanks,
Rakesh