Untitled
unknown
sqlserver
14 days ago
1.0 kB
2
Indexable
Never
USE [ITC_PCPB_KOL] GO /****** Object: Table [dbo].[Product_Master] Script Date: 05-09-2024 13:33:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Product_Master]( [Entrytime] [datetime] NULL, [SerialNo] [int] IDENTITY(1,1) NOT NULL, [Product] [varchar](300) NOT NULL, [SKU] [varchar](300) NOT NULL, [Itemcode] [varchar](300) NOT NULL, [SKUCapacity] [varchar](max) NULL, [UOM] [varchar](50) NULL, [CaseCapacity] [float] NULL, [CreatedBy] [varchar](max) NULL, [BusinessUnit] [varchar](max) NULL, CONSTRAINT [PK_Product_Master] PRIMARY KEY CLUSTERED ( [Product] ASC, [SKU] ASC, [Itemcode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[Product_Master] ADD CONSTRAINT [DF_Product_Master_Entrytime] DEFAULT (getdate()) FOR [Entrytime] GO
Leave a Comment