aa_dwh.Datenbank.sql 410 B

123456789101112131415
  1. CREATE TABLE [aa_dwh].[Datenbank] (
  2. [CLIENT_DB] [varchar](20) NOT NULL,
  3. [System] [varchar](20) NULL,
  4. [Server] [varchar](50) NULL,
  5. [Datenbank] [varchar](50) NULL,
  6. [Benutzer] [varchar](50) NULL,
  7. [Praefix] [varchar](20) NULL,
  8. [Aktiv] [smallint] NOT NULL
  9. CONSTRAINT [DF__Datenbank__Aktiv__5BE2A6F2] DEFAULT ('1')
  10. ,CONSTRAINT [PK_Datenbank] PRIMARY KEY CLUSTERED ([CLIENT_DB])
  11. )
  12. GO