Answers for "how to rename schema in sql server"

SQL
3

tsql rename table

-- SQL SERVER -- don't put the schema in the 'new_name' field, otherwise your table might end up looking something like schema.schema.new_name
EXEC sp_rename 'schema.old_name', 'new_name';
Posted by: Guest on October-08-2021
1

rename table sql server

exec sp_rename 'schema.old_table_name', 'new_table_name'
Posted by: Guest on October-28-2021

Code answers related to "how to rename schema in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language