怎么将表名改成大写?

[gslrq]

我想将SQL Server 中的数据导入ＯＲＡＣＬＥ，需将表名改成大写，手工改太麻烦，有什么好办法吗？

[CrazyFor]

循环sysobjects表,语句修改表名.

[123456754321]

ALTER TABLE t1 RENAME t2;也不行？

[mengxianbao1521]

循环sysobjects表,语句修改表名.

不行的,我试过了!


什么意思啊??为什么不行呢

[伍子V5]

你应该先
sp_configure 'allow update','1'
reconfigure with override

[newdongkui]

declare @name nvarchar(255) , @xs nvarchar(1024)

DECLARE name_cursor CURSOR FOR
SELECT name from sysobjects where xtype = 'U' and name <> 'dtproperties'
OPEN name_cursor
FETCH NEXT FROM name_cursor into @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @xs = 'exec sp_rename '''+ @name + ''' ,'''+ upper( @name ) + ''''
exec ( @xs )
FETCH NEXT FROM name_cursor into @name
END
CLOSE name_cursor
DEALLOCATE name_cursor

[sql1]

sp_configure 'allow update','1'
reconfigure with override
循环sysobjects表,语句修改表名.

[gslrq]

不行的,我试过了!