benjaminvr

Locking feature updated SQL

Jan 1st, 2022
433
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.66 KB | None | 0 0
  1. /****** Object:  Table [dbo].[Tankkaart]    Script Date: 01/01/2022 17:33:01 ******/
  2. SET ANSI_NULLS ON
  3. GO
  4.  
  5. SET QUOTED_IDENTIFIER ON
  6. GO
  7.  
  8. CREATE TABLE [dbo].[Tankkaart](
  9.     [Id] [int] IDENTITY(1,1) NOT NULL,
  10.     [Kaartnummer] [VARCHAR](60) NOT NULL,
  11.     [Vervaldatum] [DATE] NOT NULL,
  12.     [Pincode] [VARCHAR](50) NULL,
  13.     [IsGeblokkeerd] [bit] NOT NULL,
  14.  CONSTRAINT [PK_Tankkaart] PRIMARY KEY CLUSTERED
  15. (
  16.     [Id] ASC
  17. )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]
  18. ) ON [PRIMARY]
  19. GO
  20. ALTER TABLE [dbo].[Tankkaart] ADD  DEFAULT ((0)) FOR [IsGeblokkeerd]
  21. GO
Advertisement
Add Comment
Please, Sign In to add comment