By the beard of the Prophet, it works!!!

SQL Server actually converted the "US" character (Unit Separator) into a space, thus turning half of the table's name into an alias....

Update:

I've found that when SELECTing the table with the non-printable character, the reason why it returns results from another table, is that during parsing, SQL Server removes the part...

Thank you guys, for the replies and for your time.

WayneS (9/21/2015)

---

I just tested this out... since you can copy it into NotePad++, try the DDL as:

DROP TABLE [<table name...

Hi, Lowell. Thanks for replying.

Unfortunately, this table cannot be found on sys.tables. Given this, I wondered if it in fact was a view or a synonym, but cannot find...

Hi, John. Thanks for your reply.

Unfortunately, the table isn't shown under the GUI 🙁

Furthermore, this weird table neither shows up when I search for it in systems views...

Hi Guys.

I did some Identation to the code, to ease its readability and understanding. 😎

Thanks, Vidyadhar!

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TRUNCATE_PARTITION]') AND type...

Hi Paul.

Actually, it doesn't removes the partition. On SWITCH command, only the data on the master partition is Switched to the staging one.

To remove the partition (thus emulating the...

I think you are looking for a Source To Target (STT matrix) solution.

Several vendors (include some open-source) delivers this concept for ETL documenting and forward engineering.

Give it a...