How to save a table in another name

rohan1958 · #1 (**permalink**) January 29th, 2005, 08:22 AM

I have a table named employee details. as it changes everymonth i want to have a copy for each month how can i do it.

For example like Jan2005, Feb 2005 etc.

dartcoach · #2 (**permalink**) January 29th, 2005, 03:22 PM

Try using the copyobject method.

Bob Bedell · #3 (**permalink**) January 29th, 2005, 09:11 PM

Select the table in the database window, select File --> SaveAs, then rename it (just in case you aren't interested in trying it programmatically).

Bob

mmcdonal · #4 (**permalink**) January 31st, 2005, 09:36 AM

If you are doing monthly maintenance, right click on the table, select copy. Then right click in the Tables object, and click Paste. The paste dialog box will as you if you want to paste the structure, or the structure and data. Select Structure and Data, then rename it in the Save dialog box that comes up.

mmcdonal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to save queries in the table	benz_jie2005	SQL Server 2005	3	June 7th, 2007 04:48 AM
how i can save my file content into a table	chandanbhakuni	Classic ASP Professional	0	July 14th, 2006 07:23 AM
Save date in to a table	suhabassam	JSP Basics	3	September 26th, 2005 04:49 PM
dropdown save into sql table	noor	ASP.NET 1.0 and 1.1 Basics	3	January 3rd, 2005 12:36 AM
size of table (type table is table of number)	MikoMax	Oracle	1	November 19th, 2003 03:11 AM