Question: I've been having this doubt for a quite a while and haven't been able to find a satisfying answer. Is the 'E#' note technically an F? If so, why does it not exist on the chromatic scale like other sharps? I mean, what exactly is the E#? Is it a note on its own or is it just another way of saying F?

And what do people mean when they say that the D# Major scale is theoretical major scale and why it does not exist in the circle of fifths diagram?

I came across the last paragraph on a website.

Answer: 
E# is not technically F, only in equal tempered tuning. That's the first cause of concern.

The degrees of any scale follow a sequence and that sequence is never broken. The note names follow the "musical alphabet" {A, B, C, D, E, F, G} then repeat. Accidentals are needed to preserve the whole step - half step sequence {1, 1, 1/2, 1, 1, 1, 1/2} which is two tetra chords separated by a whole step. The numbered degrees are simply {1, 2, 3, 4, 5, 6, 7}. So for example, in the Key of E the degree letter names are {E, F, G, A, B, C, D} repeat. To preserve the steps we raise or lower notes as needed, for this example we get {E, F#, G#, A, B, C#, D#}. The second degree of E is always an F of some sort (period). Now in your example the key is D#. The correct way to name notes is to take D and just make everything #, Key of D = {D, E, F#, G, A, B, C#}. The key of D# would be {D#, E#, F##, G#, A#, B#, C##}. If the E# bothers you, why not ask about the futility of F## and C##? Using enharmonicity of the equal tempered tuning one would usually notate this key as Eb, which takes a lot less effort to notate correctly.
For starters, there isn't an E# in the D major scale. There's E and there's F#. If you're asking why there may be E# found in a piece that's in D major, that's slightly different.

Sometimes certain notes that are non-diatonic need to be used. That's maybe where E# could come in. Let's say the chord sequence goes from D major into F# minor. There's often the V of the new chord that precedes it. Here, it would be C# or C#7. Now the spelling for that is C# E# and G#. It is **not** spelled C# F and G#.

There are other times and reasons why some notes are written in 'strange' ways, but there are generally good technical reasons for them. And just because these notes happen to be white keys on a piano doesn't mean they can't be called # or b. These being - B#, Cb, E# and Fb. Of course, for beginners, things like E# sound pretty silly, why not F instead? Correctness and technical reasons!

**EDIT** - now the question has been edited, this answers a rather different one! Thanks! I'll leave this up for now, (OP originally asked about E# in a D major key), as it goes a little way. Luckily, I noticed the edit, otherwise I'd look even more stupid than usual.