select count(1) from syscolumns where id = object_id(‘TableName‘)
select * from syscolumns where id = object_id(‘TableName‘)
SELECT MAX(colid) FROM syscolumns WHERE id=OBJECT_ID(‘TableName‘)
摘自=>https://www.cnblogs.com/ShaYeBlog/p/4246562.html
原文：https://www.cnblogs.com/TwoBamboo/p/12806783.html