different default value between HeidiSQL and SSMS (MSSQL client)

[expired user #11422]'s profile image [expired user #11422] posted 6 years ago in General Permalink

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.