Dumping some internal views, such as sys.system_objects
as done in this question I see that some identifiers end with a dollar-sign $
CREATE VIEW sys.system_objects AS
-- cutout
FROM sys.sysschobjs$ o -- XXX: HERE
LEFT JOIN sys.syspalnames n
-- not relevant
And, this works too
SELECT * FROM sys.sysschobjs$;
Even if only by convention, what is the rule here regarding this? Should I be using this in my own code?
Searching I see a lot of stuff about Excel (which is unrelated), and Money literals (which is also unrelated).
I posted another question which I thought was unrelated, but I believe this terminal $
will shed a lot more light on it. Feel free to check that question for an example of some confusion