Object Explorer Doesn't show the full DATETIME declaration - Low Priority bug

In the below graphic you will see that the TS_KY_TOT is a Datetime2(7), where
the ‘(7)’ is the variant for precision. However the Object explorer
should be displaying this level of detail.]

This should be considered a lower level bug or new feature request, for most
programmers know what they are doing here, HOPEFULLY. It just would be nice to
have Object Explorer show the correct details.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

image001.gif

image002.jpeg

This is a Toad SQL Server 5.5 release issue.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

This is a Toad SQL Server 5.5 release issue.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image002.jpeg

This is a Toad SQL Server 5.5 release issue.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image001.gif

Hi Hank,

I’ve created CR88635 for this. Thanks for the info.

regards,

Alexander Maximov
image002.jpeg

Hi Hank,

I’ve created CR88635 for this. Thanks for the info.

regards,

Alexander Maximov
image001.gif

Hi Hank,

I’ve created CR88635 for this. Thanks for the info.

regards,

Alexander Maximov

Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.

CREATE TABLE [dbo].[PREM_COND] (

[KY_PREM_NO] int NULL ,

[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TS_KY] datetime2( 7 ) NULL ,

[CD_STAT] numeric( 2 , 0 ) NULL ,

[DT_STAT] datetime2( 7 ) NULL ,

[QY_BTU] numeric( 9 , 0 ) NULL ,

[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )

ON [PRIMARY]

WITH (DATA_COMPRESSION = PAGE) ;

GO

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image004.jpeg

Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.

CREATE TABLE [dbo].[PREM_COND] (

[KY_PREM_NO] int NULL ,

[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TS_KY] datetime2( 7 ) NULL ,

[CD_STAT] numeric( 2 , 0 ) NULL ,

[DT_STAT] datetime2( 7 ) NULL ,

[QY_BTU] numeric( 9 , 0 ) NULL ,

[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )

ON [PRIMARY]

WITH (DATA_COMPRESSION = PAGE) ;

GO

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image001.gif

Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.

CREATE TABLE [dbo].[PREM_COND] (

[KY_PREM_NO] int NULL ,

[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TS_KY] datetime2( 7 ) NULL ,

[CD_STAT] numeric( 2 , 0 ) NULL ,

[DT_STAT] datetime2( 7 ) NULL ,

[QY_BTU] numeric( 9 , 0 ) NULL ,

[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )

ON [PRIMARY]

WITH (DATA_COMPRESSION = PAGE) ;

GO

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

Alex , I just noticed that it doesn’t show up in the Detail explorer
either as shown in these details.

CREATE TABLE [dbo].[PREM_COND] (

[KY_PREM_NO] int NULL ,

[CD_PREM_COND] varchar( 3 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[TS_KY] datetime2( 7 ) NULL ,

[CD_STAT] numeric( 2 , 0 ) NULL ,

[DT_STAT] datetime2( 7 ) NULL ,

[QY_BTU] numeric( 9 , 0 ) NULL ,

[CD_ARCHIVE] varchar( 1 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[CD_PREM_COND_PRTY] numeric( 2 , 0 ) NULL )

ON [PRIMARY]

WITH (DATA_COMPRESSION = PAGE) ;

GO

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image002.jpeg