Displays the current host computer name of the client process.
host_name()
select host_name()
------------------------------ violet
host_name, a system function, returns the current host computer name of the client process (not the server process).
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute host_name.
Documentation Transact-SQL Users Guide
Function host_id