sqlserver查询一个表有多少列

发布时间：2020-12-12 14:30:05 所属栏目：MsSql教程来源：网络整理

导读：select?count(1)?from?syscolumns?where?id?=?object_id('tbname') 或者 select?*?from?syscolumns?where?id?=?object_id('tbname') 或 SELECT?MAX(colid)?FROM?syscolumns?WHERE?id=OBJECT_ID('table')? -- 查询某张表有多少条数据 SELECT SUM(rows) AS cou

select?count(1)?from?syscolumns?where?id?=?object_id('tbname')
或者
select?*?from?syscolumns?where?id?=?object_id('tbname')
或

SELECT?MAX(colid)?FROM?syscolumns?WHERE?id=OBJECT_ID('table')?

-- 查询某张表有多少条数据

SELECT SUM(rows) AS counts FROM sys.partitions WHERE object_id = object_id(N'Com_User',N'U')

?U是用户表 N代表unicode字符集?

（编辑：李大同）

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