7/9/2023 0 Comments Mtasa free object idSystem functions can be used in the select list, in the WHERE clause, and anywhere an expression is allowed. For example: SELECT OBJECT_ID('tempdb.#mytemptable'). When a temporary table name is specified, the database name must come before the temporary table name, unless the current database is tempdb. Built-in functions must always be followed by parentheses. When the parameter to a system function is optional, the current database, host computer, server user, or database user is assumed. For more information, see Metadata Visibility Configuration. This means that metadata-emitting, built-in functions such as OBJECT_ID may return NULL if the user does not have any permission on the object. Return Typesįor a spatial index, OBJECT_ID returns NULL.Ī user can only view the metadata of securables that the user owns or on which the user has been granted permission. For a list of object types, see the type column in sys.objects (Transact-SQL). If object_type is varchar, it is implicitly converted to nvarchar. object_type is either varchar or nvarchar. Specifying the database and schema names is optional. If object_name is varchar, it is implicitly converted to nvarchar. object_name is either varchar or nvarchar. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 Comments
Leave a Reply. |