Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.
USE [myDatabase] GO /****** Object: Table [dbo].[tbl_sysEntities] Script Date: 08/13/2014 11:35:16 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tbl_sysEntities]( [Entity_ID] [int] IDENTITY(1,1) NOT NULL, [Entity_Type_ID] [smallint] NOT NULL, [DS_ID] [int] NOT NULL, [DS_PK_Integer] [int] NULL, [DS_PK_Text] [nvarchar](50) NULL, [Entity_Name] [nvarchar](75) NULL, [County_ID] [int] NOT NULL, [API] [nvarchar](20) NULL, [Status_ID] [int] NOT NULL, [Eff_Date] [date] NULL, [Thru_Date] [date] NULL, [Parent_Entity_ID] [int] NULL, CONSTRAINT [PK_tbl_Entities] PRIMARY KEY CLUSTERED ( [Entity_ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[tbl_sysEntities] ADD CONSTRAINT [DF_tbl_Entities_Status_ID] DEFAULT ((1)) FOR [Status_ID] GO
Join the community of 500,000 technology professionals and ask your questions.