Edit shchima table in sql

declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema   varchar(1000)

  set @oldschema = 'hts-shop_com_User'
  set @newschema = 'dbo'

 while exists(select * from sys.tables where schema_name(schema_id) = @oldschema)
  begin
      select @table = name from sys.tables 
      where object_id in(select min(object_id) from sys.tables where  schema_name(schema_id)  = @oldschema)

    set @sql = 'alter schema ' + @newschema + ' transfer [' + @oldschema + '].' + @table
	print @sql
   exec(@sql)
 end

Similar codes

3 votes175 views4 answers
Stop MySQL
SQL
0 vote167 views1 answer
Deny select insert update delete sql
SQL
17 votes163 views2 answers
How to assign date field for table in mysql
SQL
10 votes184 views4 answers
Else if mysql
SQL
0 vote162 views1 answer
Sql delimiter to columns
SQL
0 vote179 views1 answer
How to insert multiple rows in mysql using laravel
SQL
1 vote171 views2 answers
Mysql extract month
SQL
1 vote181 views1 answer
Query for all indexes in table postgres
SQL
1 vote183 views1 answer
Oracle sequence last_number
SQL
0 vote238 views1 answer
What is common table expression in sql
SQL