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

0 vote238 views1 answer
Check if a word appears at the end sql query
SQL
-1 vote259 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
7 votes250 views4 answers
Mysql delete older duplicates
SQL
0 vote287 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
0 vote243 views1 answer
Take sql dump in to file
SQL
0 vote272 views1 answer
Change filed order in mysql
SQL
-1 vote248 views1 answer
Sql getdate date only
SQL
0 vote251 views1 answer
Ora 00001 error catch plsql
SQL
22 votes280 views4 answers
Date format mysql
SQL
-1 vote252 views2 answers
How to select the lowest values from table per client sql
SQL