Re: Delete table data
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Thu, 26 May 2005 13:06:29 -0400
It might be best to script out all the objects, drop the db and recreate it
again. Just make sure to have a backup and make sure you script out all the
objects including indexes, triggers etc.
--
Andrew J. Kelly SQL MVP
"Ryan Langton" <langton@xxxxxxxxxxxxxxxxxx> wrote in message
news:uJiCyzgYFHA.3280@xxxxxxxxxxxxxxxxxxxxxxx
> Is there any easy way to clear all table data for a SQL server database?
> I have a SQL server for which I've been using old data to test. Now that
> it is going out into production next week I need to clear all table data
> so that I can import their current data without violating any primary
> keys.
>
> Thanks,
> Ryan
>
.
- References:
- Delete table data
- From: Ryan Langton
- Delete table data
- Prev by Date: Re: "Waiting on previous installation" error
- Next by Date: Sql Server - Memory Question
- Previous by thread: Delete table data
- Next by thread: Sql Server - Memory Question
- Index(es):
Relevant Pages
|
Loading
