CREATE TABLE [dbo].[Warehouse] (
[id] int IDENTITY(100000,13) NOT NULL,
[Name] varchar(50) COLLATE Latin1_General_CI_AS NOT NULL,
[Pic] int NULL,
[Address] varchar(255) COLLATE Latin1_General_CI_AS NULL,
[Phone] varchar(100) COLLATE Latin1_General_CI_AS NULL,
[Email] varchar(100) COLLATE Latin1_General_CI_AS NULL,
[CreatedAt] datetime DEFAULT getdate() NOT NULL,
[CreatedBy] int NULL,
[UpdatedAt] datetime NULL,
[UpdatedBy] int NULL,
[DeletedAt] datetime2(7) NULL,
CONSTRAINT [PK__Warehous__3213E83F370511FC] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Warehouse] SET (LOCK_ESCALATION = TABLE)
GO
CREATE NONCLUSTERED INDEX [idx_warehouse_name]
ON [dbo].[Warehouse] (
[Name] ASC
)
please let me know what’s the proble with this situation.
thank you