请问:C#如何读取Oracle数据库中的表结构(表名,字段名,字段类型,备注)等
求高手解答
求高手解答
解决方案 »
- C#钩子问题,高人帮忙看一下!
- 用C#图书管理系统
- 急:PDA访问WEB SERVICE代理时要输入用户名、密码如何处理
- ETL,如何处理这样的数据?
- 关于 c#应用程序 再次升级的问题.
- c#在做向数据库中添加数据的时候怎么把像<script>alert('ffffffff')</script>过滤掉
- 右击 ContextMenuStrip 怎样获得它背后的对象详细信息呢?
- 请问,c#winform开发中,界面没有用到数据集,数据填充table到datagrid,我现在想用vs.net2003还到报表打印怎么做?
- sqldatasource 同时绑定多个表的方法
- 托盘提示信息的受控显示
- 按钮实现Panel的左右移动,求大神帮忙看一下
- 如何给textbox添加双击事件
Syscolumns.Name As 列名,
Systypes.Name As 列类型,
Syscolumns.Length As 列长度,
Isnull(Sysproperties.Value, Syscolumns.Name) As 列说明,
Case
When Syscolumns.Name In
(Select 主键 = A.Name
From Syscolumns A
Inner Join Sysobjects B On A.Id = B.Id
And B.Xtype = 'U'
And B.Name <> 'Dtproperties'
Where Exists (Select 1
From Sysobjects
Where Xtype = 'Pk'
And Name In
(Select Name
From Sysindexes
Where Indid In
(Select Indid
From Sysindexkeys
Where Id = A.Id
And Colid = A.Colid)))
And B.Name = Sysobjects.Name) Then
1
Else
0
End As 是否主键
From Sysobjects, Systypes, Syscolumns
Left Join Sysproperties On (Syscolumns.Id = Sysproperties.Id And
Syscolumns.Colid = Sysproperties.Smallid)
Where (Sysobjects.Xtype = 'U' Or Sysobjects.Xtype = 'V')
And Sysobjects.Id = Syscolumns.Id
And Systypes.Xtype = Syscolumns.Xtype
And Systypes.Name <> 'Sysname'
And Sysobjects.Name Like '%'
Order By Sysobjects.Name, Syscolumns.Colid
的是
SELECT * FROM TAB;
SELECT TABLE_NAME,COLUMN_NAME FROM user_tab_columns;