i trying rename table on sql server using following command: alter table <schema>.<old_name> rename <new_name>;
the table small: approximately 500 rows 15 columns. command runs more 15 minutes before kill it. have verified have permissions rename tables since have renamed couple of other tables in same schema (which took less minute because empty). suggestions?
copy data table (select * into), drop , recreate table using correct name, insert data in.
Comments
Post a Comment