How can I rename a user-created SYSUSERS table?
S开发者_C百科omeone renamed our Users table to SYSUsers, which is a key sql table name. Is there a way to rename this table?
I've tried right-clicking the table and going to rename, and running sp_RENAME
on it, but both are trying to rename the system sysusers table instead of the user-created one. I can't even select or export data from the [MyDatabase].[dbo].[SYSUsers]
since it reads from the sql server sysusers table instead of the user-created one.
We're using SQL Server 2005.
SYSUsers
doesn't cause any such problem for me because I work on a case sensitive instance (however creating a table called sysusers
does!).
Perhaps you could try temporarily altering the collation of the database to a CS
one and switch it back after?
精彩评论