While craeting 2nd table with foreign key getting an error?

Hi try the below scripts

 

 

--=================

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ARITHABORT ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_AddItems](
[id] [int] IDENTITY(1,1) NOT NULL,
[ProductId] AS ('SHPLT'+right('0000'+CONVERT([varchar](10),[ID],(0)),(4))) PERSISTED NOT NULL,
[ProductCategory] [varchar](20) NULL,
[ProductName] [varchar](30) NULL,
[Price] [decimal](6, 2) NULL,
[ProductCode] [varchar](20) NULL,
[Descriptions] [varchar](max) NULL,
[Stock] [int] NULL,
[Discount] [int] NULL,
CONSTRAINT [PK_ProductId] PRIMARY KEY CLUSTERED
(
[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

 

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tbl_AddImages](
[Id] [int] IDENTITY(1,1) NOT NULL,
[ProductId] AS ('SHPLT'+right('0000'+CONVERT([varchar](10),[ID],(0)),(4))) PERSISTED NOT NULL,
[ImgId] [varchar](20) NULL,
[ImgPath] [varchar](100) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_AddImages] WITH CHECK ADD CONSTRAINT [FK_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[tbl_AddItems] ([ProductId])
GO

ALTER TABLE [dbo].[tbl_AddImages] CHECK CONSTRAINT [FK_ProductId]
GO


 

 Execute below script: 

 

 

SET ANSI_NULLS ON;

SET ANSI_PADDING ON;

SET ANSI_WARNINGS ON;

SET ARITHABORT ON;

SET CONCAT_NULL_YIELDS_NULL ON;

SET NUMERIC_ROUNDABORT ON;

SET QUOTED_IDENTIFIER ON;

 

After executing above code please try to create table.