This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › SQL Server empties the data in the table
View: 13495|Reply: 1

[Source] SQL Server empties the data in the table

[Copy link]
Posted on 12/3/2020 11:42:28 AM | | | |
Requirements: Empty the data of all tables in the database, and keep only one user, the admin of the users table, that is, restore the initial state of the database.

First, attach the script, written by yourself, as follows:

There is a pit in this, some tables are not created by me, and I can't see them, so I shouldn't empty those table databases, as shown in the figure below:



MSsubscription_agents tables are used by the distribution agent and the updateable subscriber's triggers to track subscription attributes. This table is stored in the subscriber database.
MSreplication_objects Each object associated with replication in the subscriber database occupies a row in the MSreplication_objects table. This table is stored in the subscription database.





Previous:python uses mirror stations to speed up pip downloads
Next:SQL SERVER looks at the database connection and disconnects

Related Posts
 Landlord| Posted on 12/27/2020 10:30:59 PM |
The query contains a schema

Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com