Advertisement
vavisv

Untitled

Feb 18th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. CREATE TABLE [dbo].[obj](
  2.     [obj_id] [int] PRIMARY KEY CLUSTERED ,
  3.     [obj_name] [nvarchar](20))
  4.  
  5.  
  6.  
  7. CREATE TABLE [dbo].[obj_fields](
  8.     [fie_id] [int] NULL,
  9.     [fie_name] [nvarchar](20) NULL,
  10.     [ref_obj_id] [int] NULL
  11. )
  12.  
  13.  
  14. ALTER TABLE [dbo].[obj_fields]  WITH CHECK ADD  CONSTRAINT [FK_obj_fields_obj] FOREIGN KEY([ref_obj_id]) REFERENCES [dbo].[obj] ([obj_id])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement