different default value between HeidiSQL and SSMS (MSSQL client)

nanun posted 11 months ago in General

Hi all.

I'm using HeidiSQL as the client of MSSQL. The version of SQL Server is 12.0.5207.

and I found the displayed default value is different between HeidiSQL and SSMS.

Following are what I made create table scripting by ssms.

USE [UserDB]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_User](
    [UID] [int] IDENTITY(1,1) NOT NULL,
    {more columns}
    [GM_User] [tinyint] NOT NULL,
    {more columns}
GO

{more alter}

ALTER TABLE [dbo].[tbl_User] ADD  CONSTRAINT [DF_tbl_User_GM_User]  DEFAULT ((3)) FOR [GM_User]
GO


{more alter}

I expect the default value as 3, but the HeidiSQL says No Default

I tested HeidiSQL 9.5.0.5196 64bit and 9.5.0.5269 64bit and both are same.

Somebody know about this?

Thanks.

Please login to leave a reply, or register at first.