SHARE
TWEET

Untitled

a guest Jun 20th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE [dbo].[CIC_DESLUNGHE](
  2.     [CD_CIC_DESLUNGHE] [bigint] IDENTITY(1,1) NOT NULL,
  3.     [CD_CIC_PRODUZIONE] [bigint] NOT NULL,
  4.     [CD_CIC_OPERAZIONI] [bigint] NOT NULL,
  5.     [AFNMPROG] [int] NOT NULL,
  6.     [AFDSLINE] [nvarchar](max) NULL,
  7.  CONSTRAINT [PK_CIC_DESLUNGHE] PRIMARY KEY CLUSTERED
  8. (
  9.     [CD_CIC_DESLUNGHE] ASC
  10. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 99) ON [PRIMARY]
  11. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  12. GO
  13.  
  14.  
  15. CREATE TABLE [dbo].[CIC_DESLUNGHE_STORICI](
  16.     [CD_CIC_DESLUNGHE_STORICI] [bigint] IDENTITY(1,1) NOT NULL,
  17.     [CD_CIC_PRODUZIONE_STORICI] [bigint] NOT NULL,
  18.     [CD_CIC_OPERAZIONI_STORICI] [bigint] NOT NULL,
  19.     [AFNMPROG] [int] NOT NULL,
  20.     [AFDSLINE] [nvarchar](max) NOT NULL,
  21.  CONSTRAINT [PK_CIC_DESLUNGHE_STORICI_1] PRIMARY KEY CLUSTERED
  22. (
  23.     [CD_CIC_DESLUNGHE_STORICI] ASC
  24. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  25. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  26. GO
  27.      
  28. Table                   Rows        TotalSpace MB
  29. CIC_DESLUNGHE_STORICI   12.709.497  48214,75
  30. CIC_DESLUNGHE           24.827.337  5675,49
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top