Advertisement
Guest User

FingerPrint

a guest
Jun 21st, 2019
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.67 KB | None | 0 0
  1. CREATE TABLE [dbo].[FingerPrintFeatures](
  2.     [Id] [int] IDENTITY(1,1) NOT NULL,
  3.     [FingerPrintByte] [varbinary](max) NOT NULL,
  4.     [BiodataId] [uniqueidentifier] NOT NULL,
  5.  CONSTRAINT [PK_FingerPrintFeatures] PRIMARY KEY CLUSTERED
  6. (
  7.     [Id] ASC
  8. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  9. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  10. GO
  11.  
  12. ALTER TABLE [dbo].[FingerPrintFeatures]  WITH CHECK ADD  CONSTRAINT [FK_FingerPrintFeatures_Biodata] FOREIGN KEY([BiodataId])
  13. REFERENCES [dbo].[Biodata] ([Id])
  14. GO
  15.  
  16. ALTER TABLE [dbo].[FingerPrintFeatures] CHECK CONSTRAINT [FK_FingerPrintFeatures_Biodata]
  17. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement