Hi, Everybody!
Can anyone PLEASE enlighten me as to WHY SQL Server Management Studio (v17.4) would flag the following columns as invalid?... The ones with the squiggly red underlines?
Please see table definition below…
USE [TrackingService]
GO
/****** Object: Table [dbo].[TrackingData] Script Date: 5/20/2021 8:51:16 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TrackingData](
[TrackingDataID] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[Carrier] [nvarchar](10) NULL,
[EventCode] [nvarchar](10) NULL,
[EventDescription] [nvarchar](50) NULL,
[EventDateTimeUTC] [datetime] NULL,
[EventCity] [nvarchar](50) NULL,
[EventCountryCode] [nvarchar](2) NULL,
[EventCountry] [nvarchar](50) NULL,
[Mailbag] [nvarchar](50) NULL,
[FreightForwarder] [nvarchar](50) NULL,
[Hawb] [nvarchar](50) NULL,
[Mawb] [nvarchar](50) NULL,
[ItemID] [nvarchar](20) NULL,
[CustomerItemID] [nvarchar](20) NULL,
[DestinationCity] [nvarchar](50) NULL,
[DestinationState] [nvarchar](50) NULL,
[DestinationZip] [nvarchar](50) NULL,
[DestinationCountryCode] [nvarchar](50) NULL,
[DestinationCountry] [nvarchar](50) NULL,
[CustomerNumber] [char](10) NULL,
[ClientNumber] [nvarchar](20) NULL,
[ClientName] [nvarchar](50) NULL,
[MsiTrackingID] [nvarchar](20) NULL,
[VendorTrackingID] [nvarchar](20) NULL,
[FinalCarrierTrackingID] [nvarchar](20) NULL,
[FinalCarrierVendor] [nvarchar](50) NULL,
[FileID] [char](13) NULL,
[SendOutDateUTC] [datetime] NULL,
[CreatedDataTimeUTC] [datetime] NOT NULL,
[LgTrackID] [nvarchar](20) NULL,
[CaTrackID] [nvarchar](20) NULL,
[Bc] [nvarchar](50) NULL,
CONSTRAINT [PK_TrackingData] PRIMARY KEY CLUSTERED
(
[TrackingDataID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO