Metadata Functions (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
The following scalar functions return information about the database and database objects:
All metadata functions are nondeterministic. This means these functions do not always return the same results every time they are called, even with the same set of input values.