@@MAX_PRECISION (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL database in Microsoft Fabric

Returns the precision level used by decimal and numeric data types as currently set in the server.

Transact-SQL syntax conventions

Syntax

@@MAX_PRECISION  

Return Types

tinyint

Remarks

By default, the maximum precision returns 38.

Examples

SELECT @@MAX_PRECISION AS 'Max Precision'  

See Also

Configuration Functions (Transact-SQL)
decimal and numeric (Transact-SQL)
Precision, Scale, and Length (Transact-SQL)