sys-system-parameters-transact-sql.md

title	sys.system_parameters (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.service
ms.component	system-catalog-views
ms.reviewer
ms.suite	sql
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sys.system_parameters sys.system_parameters_TSQL system_parameters_TSQL system_parameters
dev_langs	TSQL
helpviewer_keywords	sys.system_parameters catalog view
ms.assetid	0d135c5f-68b5-4009-a0da-35e6abfee0ff
caps.latest.revision	35
author	edmacauley
ms.author	edmaca
manager	craigg
ms.workload	Inactive

sys.system_parameters (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

Contains one row for each system object that has parameters.

Column name	Data type	Description
object_id	int	ID of the object to which this parameter belongs.
name	sysname	Name of the parameter. Is unique within the object. If the object is a scalar function, the parameter name is an empty string in the row representing the return value.
parameter_id	int	ID of the parameter. Is unique within the object. If the object is a scalar function, parameter_id = 0 represents the return value.
system_type_id	tinyint	ID of the system type of the parameter.
user_type_id	int	ID of the type of the parameter as defined by the user. To return the name of the type, join to the sys.types catalog view on this column.
max_length	smallint	Maximum length of the parameter, in bytes. Value will be -1 for when column data type is varchar(max), nvarchar(max), varbinary(max), or xml.
precision	tinyint	Precision of the parameter if numeric-based; otherwise, 0.
scale	tinyint	Scale of the parameter if numeric-based; otherwise, 0.
is_output	bit	1 = Parameter is output (or return); otherwise, 0.
is_cursor_ref	bit	1 = Parameter is a cursor-reference parameter.
has_default_value	bit	1 = Parameter has default value. [!INCLUDEssNoVersion] only maintains default values for CLR objects in this catalog view; therefore, this column will always have a value of 0 for [!INCLUDEtsql] objects. To view the default value of a parameter in a [!INCLUDEtsql] object, query the definition column of the sys.sql_modules catalog view, or use the OBJECT_DEFINITION system function.
is_xml_document	bit	1 = Content is a complete XML document. 0 = Content is a document fragment or the data type of the column is not xml.
default_value	sql_variant	If has_default_value is 1, the value of this column is the value of the default for the parameter; otherwise NULL.
xml_collection_id	int	Non-zero if the data type of the parameter is xml and the XML is typed. The value is the ID of the collection that contains the validating XML schema namespace for the parameter. 0 = There is no XML schema collection.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ
sys.parameters (Transact-SQL)
sys.all_parameters (Transact-SQL)