|M| 怎么查找出数据库中列名有Discountpoint的表名 多谢

|M| 如何查找出数据库中列名有Discountpoint的表名 谢谢
如题

[解决办法]
如果是SqlServer,可以在sysobjects中查找指定名称的表.
[解决办法]
select * from sysobjects where xtype= 'u 'and id in(select id from syscolumns where name= 'Discountpoint ')
[解决办法]
syscolumns 这个表是放置 字段信息的。
[解决办法]
1: 自己换成vb的吧. protected void Page_Load(object sender, EventArgs e) { System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo( "c:\\Inetpub "); this._BindDir(dir, this.TreeView1.Nodes); } void _BindDir(DirectoryInfo dir, TreeNodeCollection nodes) { TreeNode node = new TreeNode(); node.Text = dir.Name; node.Value = dir.FullName; nodes.Add(node); DirectoryInfo[] dirs= dir.GetDirectories(); foreach (DirectoryInfo d in dirs) { this._BindDir(d, node.ChildNodes); } }