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.