HOST_NAME (Transact-SQL)

**APPLIES TO:** SQL Server (starting with 2016) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

Returns the workstation name.

Transact-SQL Syntax Conventions

Syntax

  
HOST_NAME ()  

Return Types

nvarchar(128)

Remarks

When the parameter to a system function is optional, the current database, host computer, server user, or database user is assumed. Built-in functions must always be followed by parentheses.

System functions can be used in the select list, in the WHERE clause, and anywhere an expression is allowed.

[!IMPORTANT]
The client application provides the workstation name and can provide inaccurate data. Do not rely upon HOST_NAME as a security feature.

Examples

The following example creates a table that uses HOST_NAME() in a DEFAULT definition to record the workstation name of computers that insert rows into a table recording orders.

CREATE TABLE Orders  
   (OrderID     int        PRIMARY KEY,  
    CustomerID  nchar(5)   REFERENCES Customers(CustomerID),  
    Workstation nchar(30)  NOT NULL DEFAULT HOST_NAME(),  
    OrderDate   datetime   NOT NULL,  
    ShipDate    datetime   NULL,  
    ShipperID   int        NULL REFERENCES Shippers(ShipperID));  
GO  

See Also

Expressions (Transact-SQL)
System Functions (Transact-SQL)