SQL Server batch modify table names

If you want to change the prefix of "SQL" table "ABC _" to "def"

First use SQL statements to query all tables with the "ABC _" prefix

Select * From sysobjects where xtype = 'U' and name like 'abc _ %'

Then modify the statement

Update sysobjects set name = Replace (name, 'abc _ ', 'def _') Where xtype = 'U' and name like 'abc _ %'

If the statement is run, "Special updates to the system directory are not enabled. The system administrator must reconfigure SQL Server to allow this operation. There are two ways to solve this problem:

 

Method 1:
Open MSSQL Server properties --- server options ---- enable special updates to the system directory (allow direct modifications to the system directory. (PS: Enterprise Manager --- tools --- SQL Server Configuration properties --- server settings --- allow direct modification to the system directory) and then execute the SQL statement in the query analyzer.

Method 2: run in the query Analyzer

Sp_configure 'Allow updates', 0 -- the value cannot be modified.
Sp_configure 'Allow updates', 1 -- allow modifications to the system table
Reconfigure with override -- update the current configuration of the configuration option changed using sp_configure system stored procedure

 

Refresh the target table.