Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
skiski
Starting Member
15 Posts |
Posted - 2010-05-27 : 03:09:07
|
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tbl_DocumentsRow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[tbl_DocumentsRow]GOCREATE TABLE [dbo].[tbl_DocumentsRow] ( [fldID] [bigint] IDENTITY (1, 1) NOT NULL , [fldXld] [tinyint] NOT NULL , [fldVAH_Code] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldSal] [int] NOT NULL , [fldMAN_Code] [int] NOT NULL , [fldSerialNo] [bigint] NOT NULL , [fldRow] [int] NOT NULL , [fldDocDt] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldGenCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldSubCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldChiCodeE] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldGenCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldSubCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldChiCode] [nvarchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldDescX] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldDesc] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [fldAmount] [bigint] NOT NULL , [fldAmountCode] [tinyint] NOT NULL , [fldAmountX] [bigint] NOT NULL , [fldElamyeNo] [int] NOT NULL , [fldGrpCodeM] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldTypeM] [tinyint] NULL , [Eftetah] [tinyint] NULL , [Ekhtetam] [tinyint] NULL , [Sood] [tinyint] NULL , [fldGrpCodeE] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [fldTypeE] [tinyint] NULL ) ON [PRIMARY]GOThe index entry of length 909 bytes for the index "IX_tbl_DocumentsRowDesc" exceeds the maximum length of 900 bytes.Thanks |
|
|
|
|
|
|