IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xx]') AND type in (N'U'))
drop table xx
go
create table x (x int)
EXEC sp_rename '[dbo].[x]', '[dbo].[xx]';
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[[dbo]].[xx]]]') AND type in (N'U'))
EXEC sp_rename '[dbo].[[dbo]].[xx]]]',
'xx';
GO
No comments:
Post a Comment