查询表信息与列信息，SQLserver

发布时间：2020-12-12 13:07:48 所属栏目：MsSql教程来源：网络整理

导读：--查询系统汇总表名与其对应的列信息 SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S COLUMN NAME" FROM sysobjects a LEFT JOIN syscolumns b ON a.id = b.id? WHERE ?a.xtype = 'U' ORDER BY a.name --oracle? SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S

--查询系统汇总表名与其对应的列信息
SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S COLUMN NAME" FROM sysobjects a LEFT JOIN syscolumns b ON a.id = b.id?

WHERE ?a.xtype = 'U' ORDER BY a.name

--oracle?

SELECT a.NAME AS TBLNAME,b.NAME AS "TABLE'S COLUMN NAME" FROM sysobjects a LEFT JOIN syscolumns b ON a.id = b.id?
WHERE ?a.xtype = 'U' ORDER BY a.name

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!