摘要: 获取数据库中所有的表SELECT SysObjects.name AS Tablename FROM sysobjects WHERE xtype = 'U'获取数据库中所有表的列名SELECT SysColumns.name AS Columnsname, SysObjects.name AS Tablename FROM SysObjects, SysColumns WHERE Sysobjects.Xtype='u' AND Sysobjects.Id=Syscolumns.Id获取SqlServer中的所有数据库,系统数据库除外Select name f 阅读全文
posted @ 2013-06-28 11:15 Follow-your-heart 阅读(1076) 评论(0) 推荐(0) 编辑