CREATE DATABASE SomeDB
GO
USE SOMEDB
GO
CREATE SCHEMA test AUTHORIZATION dbo
GO
CREATE TABLE dbo.SomeTable1 (
SomeField1 VARCHAR(255)
)
CREATE TABLE test.SomeTable1 (
SomeField1 VARCHAR(255)
)
GO
EXEC sp_rename 'dbo.SomeTable1', 'dbo.SomeTable2'
EXEC sp_rename 'test.SomeTable1', 'test.SomeTabl2'
GO
SELECT * FROM sys.objects WHERE name IN ('dbo.SomeTable2', 'test.SomeTable2')
GO
DROP TABLE [dbo.SomeTable2]
DROP TABLE [test.SomeTable2] -- Вот тут ругань Cannot drop the table 'test.SomeTable2', because it does not exist or you do not have permission.
GO
USE master
DROP DATABASE SomeDB
GO