OleDbConnection.GetOleDbSchemaTable(
OleDbSchemaGuid.Tables, new object [] {null,null,"t_user"});看看那个返回的表,我记得有备注的
OleDbSchemaGuid.Tables, new object [] {null,null,"t_user"});看看那个返回的表,我记得有备注的
解决方案 »
- 添加\修改\删除页面中使用fileupload控件问题
- 关于Access数据库OleDbDataAdapter的用法??求助..
- C#支持RSASSA-PSS的签名算法吗?
- 求C#实现稀疏矩阵的压缩存储代码
- VS2005水晶报表设计?
- Asp.net使用传统方式上传文件,如何解决,请帮忙解决,给100分!
- 出现了错误提示:这是线程间操作无效: 从不是创建控件“lstPrime”的线程访问它
- C#中用正则表达式读取某站点的所有链接或者图片,它的正则表达式如何写??
- 母版页中导航栏的图片不能显示
- datagridview列不能获得焦点
- 如何将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