Check with OBJECTPROPERTY function : OBJECTPROPERTY « System Settings « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Settings
3. OBJECTPROPERTY

5>    CREATE FUNCTION dbo.AveragePrice()
6>    RETURNS money
7>    WITH SCHEMABINDING
8>    AS
9>    BEGIN
10>       RETURN (SELECT AVG(Price) FROM dbo.Titles)
11>    END
12> GO
1>
2>    SELECT OBJECTPROPERTY(OBJECT_ID('AveragePrice'), 'IsDeterministic')
3> GO

-----------
          1

(1 rows affected)
1>
2> drop FUNCTION dbo.AveragePrice;
3> GO