SHARE
TWEET

Untitled

a guest Sep 14th, 2017 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE [CAP00]
  2. GO
  3.  
  4. /****** Object:  Table [dbo].[CAP_TipoContenedor]    Script Date: 05/30/2011 15:39:03 ******/
  5. SET ANSI_NULLS ON
  6. GO
  7.  
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10.  
  11. CREATE TABLE [dbo].[CAP_TipoContenedor](
  12.     [TCN_TipoContenedor] [INT] IDENTITY(1,1) NOT NULL,
  13.     [TCN_Descripcion] [nvarchar](100) NOT NULL,
  14.     [TCN_EST_Estado] [INT] NOT NULL,
  15.  CONSTRAINT [PK_CAP_TipoContenedor] PRIMARY KEY CLUSTERED
  16. (
  17.     [TCN_TipoContenedor] ASC
  18. )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  19. ) ON [PRIMARY]
  20.  
  21. GO
  22.  
  23. ALTER TABLE [dbo].[CAP_TipoContenedor]  WITH CHECK ADD  CONSTRAINT [FK_CAP_TipoContenedor_CAP_Estado] FOREIGN KEY([TCN_EST_Estado])
  24. REFERENCES [dbo].[CAP_Estado] ([EST_Estado])
  25. GO
  26.  
  27. ALTER TABLE [dbo].[CAP_TipoContenedor] CHECK CONSTRAINT [FK_CAP_TipoContenedor_CAP_Estado]
  28. GO
  29.  
  30. ALTER TABLE [dbo].[CAP_TipoContenedor] ADD  CONSTRAINT [DF_CAP_TipoContenedor_TCN_EST_Estado]  DEFAULT ((1)) FOR [TCN_EST_Estado]
  31. GO
RAW Paste Data
Top