Metadata Functions (Transact-SQL)
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.