Untitled
unknown
sqlserver
11 days ago
949 B
2
Indexable
Never
USE [ITC_PCPB_KOL] GO /****** Object: Table [dbo].[Line_Master] Script Date: 05-09-2024 13:41:25 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Line_Master]( [Entrytime] [datetime] NULL, [SerialNo] [int] IDENTITY(1,1) NOT NULL, [Line] [varchar](max) NULL, [Product] [varchar](300) NOT NULL, [SKU] [varchar](300) NOT NULL, [Itemcode] [varchar](300) NOT NULL, [UOM] [varchar](50) NULL, [RatedSpeed] [float] NULL, [CreatedBy] [varchar](max) NULL, CONSTRAINT [PK_Line_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].[Line_Master] ADD CONSTRAINT [DF_Line_Master_Entrytime] DEFAULT (getdate()) FOR [Entrytime] GO
Leave a Comment