我在修改数据库表时,只是将Varchar类型长度进行了增加。出现以下错误
无法修改表。 未能在 syscolumns 中找到与数据库 ID 7 中对象 ID 2117074778 所对应的列 ID 26。
Could not find column ID 26 in syscolumns for object ID 2117074778 in database ID 7.
未能除去约束。请参阅前面的错误信息。
数据库SQL2005
无法修改表。 未能在 syscolumns 中找到与数据库 ID 7 中对象 ID 2117074778 所对应的列 ID 26。
Could not find column ID 26 in syscolumns for object ID 2117074778 in database ID 7.
未能除去约束。请参阅前面的错误信息。
数据库SQL2005
select a.id,a.name as tablename,b.name as columnname
from sysobjects a inner join syscolumns b on a.id=b.id where a.xtype='U'
用4楼方法查询,是存在该列的以下是表脚本USE [db_iesoo_net]
GO
/****** 对象: Table [dbo].[BioErpTbMonthTotalSendGoods] 脚本日期: 05/26/2011 11:08:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BioErpTbMonthTotalSendGoods](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DateYear] [int] NOT NULL,
[DateMonth] [int] NOT NULL,
[SendGoodsId] [int] NULL,
[SendDate] [datetime] NULL,
[SendType] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
[OrderUnit] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ProId] [int] NULL,
[ProName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Specifications] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Manufacturer] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ProCount] [int] NULL,
[SettlementPrice] [decimal](16, 2) NULL,
[SettlementAmount] [decimal](16, 2) NULL,
[Rate] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL DEFAULT ('17%'),
[Taxes] [decimal](16, 2) NULL,
[TaxedPrice] [decimal](16, 2) NULL,
[OutPrice] [decimal](16, 2) NULL,
[PurchasePrice] [decimal](16, 2) NULL,
[StoragePrice] [decimal](16, 2) NULL,
[InvoiceDate] [datetime] NULL,
[InvoiceCount] [int] NULL,
[InvoicePrice] [decimal](16, 2) NULL,
[InvoiceID] [int] NULL,
[StoreHouseId] [int] NULL,
[SendGoodsProId] [int] NULL,
[productLevel] [varchar](10) COLLATE Chinese_PRC_CI_AS NULL,
[myCompanyId] [int] NULL,
[BatchId] [int] NULL,
[BatchNum] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[IsExpToMonth] [int] NOT NULL CONSTRAINT [DF_BioErpTbMonthTotalSendGoods_IsExpToMonth] DEFAULT (0),
[ExpirationDate] [datetime] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]GO
SET ANSI_PADDING OFF
GO
搞定了。
用SQL语句更改没问题。
但在设计视图中修改依然要出现这问题