再次100分求救!我次次都结帐!急!急!高手多帮忙 OleDbConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object [] {null,null,"t_user"});看看那个返回的表,我记得有备注的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在表上点击生成SQL脚本,在Fomatting选项卡的 Including extended properties,它会将注释也生成SQL语句,如:if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupManagers_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[GroupManagers] DROP CONSTRAINT FK_GroupManagers_GroupsGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupModules_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[GroupModules] DROP CONSTRAINT FK_GroupModules_GroupsGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupTypes_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[GroupTypes] DROP CONSTRAINT FK_GroupTypes_GroupsGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupUsers_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)ALTER TABLE [dbo].[GroupUsers] DROP CONSTRAINT FK_GroupUsers_GroupsGOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[Groups]GOCREATE TABLE [dbo].[Groups] ( [GroupID] [int] IDENTITY (1, 1) NOT NULL , [GroupName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [GroupDesc] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [CanAlter] [bit] NULL , [IsActive] [bit] NULL ) ON [PRIMARY]GOexec sp_addextendedproperty N'MS_Description', N'是否能修改', N'user', N'dbo', N'table', N'Groups', N'column', N'CanAlter'GOexec sp_addextendedproperty N'MS_Description', N'组描述', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupDesc'GOexec sp_addextendedproperty N'MS_Description', N'用户组ID', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupID'GOexec sp_addextendedproperty N'MS_Description', N'组名称', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupName'GOexec sp_addextendedproperty N'MS_Description', N'是否可用', N'user', N'dbo', N'table', N'Groups', N'column', N'IsActive'GO 具体的信息应该是存在 sysproperties 表中 超难度:这种界面在winform中能做吗?最后的分全给你们了 C# 电子秤问题, 连接电脑COM1后,鼠标指针乱跳 有人研究过qq msn 飞信这些聊天工具吗? 新版本的水晶报表能够兼容旧版本的水晶报表么? 就这问题,是都不噱于回答吗? 怎样嵌入access 如何遍历窗体上的radiobutton控件? .netWinform中DataGrid多选 截取端口的数据问题 在c#中派生类可以同时继承多个基类吗? 如何将ComboBox设置成平面的? 存储过程,一台服务器上的两个数据库数据导入,能封装在程序里吗?
ALTER TABLE [dbo].[GroupManagers] DROP CONSTRAINT FK_GroupManagers_Groups
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupModules_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GroupModules] DROP CONSTRAINT FK_GroupModules_Groups
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupTypes_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GroupTypes] DROP CONSTRAINT FK_GroupTypes_Groups
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_GroupUsers_Groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[GroupUsers] DROP CONSTRAINT FK_GroupUsers_Groups
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Groups]
GOCREATE TABLE [dbo].[Groups] (
[GroupID] [int] IDENTITY (1, 1) NOT NULL ,
[GroupName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GroupDesc] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CanAlter] [bit] NULL ,
[IsActive] [bit] NULL
) ON [PRIMARY]
GO
exec sp_addextendedproperty N'MS_Description', N'是否能修改', N'user', N'dbo', N'table', N'Groups', N'column', N'CanAlter'
GO
exec sp_addextendedproperty N'MS_Description', N'组描述', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupDesc'
GO
exec sp_addextendedproperty N'MS_Description', N'用户组ID', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupID'
GO
exec sp_addextendedproperty N'MS_Description', N'组名称', N'user', N'dbo', N'table', N'Groups', N'column', N'GroupName'
GO
exec sp_addextendedproperty N'MS_Description', N'是否可用', N'user', N'dbo', N'table', N'Groups', N'column', N'IsActive'
GO