renaming a table
- From: "Rob C" <RobC@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 15 Aug 2005 08:50:09 -0700
I am using RDA to download a table of staff records from a SQL Server Db to
my SQL CE database. My problem is that you have to drop the existing table
first. If I do that and the download fails for some reason, i have lost the
table that was there. i could first check for a valid connection before
dropping the CE table but there is still a chance it could fail for other
reasons.
i was thinking that i would rename the local CE table and then drop it if
the download succeeded or name it back to its original name if the download
fails.
I wasn't sure of the best way to do this (couldn't find anything in ALTER
TABLE).
Also, I was curious how other people might have solved this problem.
Thanks,
-Rob
.
- Follow-Ups:
- Re: renaming a table
- From: Darren Shaffer
- Re: renaming a table
- From: Joćo Paulo Figueira [eMVP]
- Re: renaming a table
- Prev by Date: Re: How to handle background replication process - SQL Mobile
- Next by Date: Re: How to handle background replication process - SQL Mobile
- Previous by thread: Native Error 0
- Next by thread: Re: renaming a table
- Index(es):
Relevant Pages
|
Loading
