SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[constraintdemo](
    [constraintfield] [int] NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[constraintdemo]  WITH CHECK ADD  CONSTRAINT [CK_constraintdemo] CHECK  (([constraintfield]>(0)))
INSERT INTO constraintdemo (constraintfield) VALUES (-1)
Msg 547 Level 16 State 0 Line 1
The INSERT statement conflicted with the CHECK constraint "CK_constraintdemo". The conflict occurred in database "fiddle_e04f669e429a4911b7420171c9be96b6", table "dbo.constraintdemo", column 'constraintfield'.
Msg 3621 Level 0 State 0 Line 1
The statement has been terminated.