SQL Equivalent to `nameof` operator in C#, Java, etc

Question

Is there an equivalent to the nameof operator in languages like C#, Java, etc for any SQL database implementations, in particular SQL Server?

If not, is there an equivalent function that can be rolled that will pass back a string (VARCHAR, etc) of a given object (for example, [dbo].[MyTable]) which is passed to it?

Answer 1

To get the name of an object, you can pass the ID. You can get the ID from the name of the object. Not sure if this is what you are looking for:

select object_name(object_id('my_table_name'))