开发者

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?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜