数据库一些操作

查询表的列数

SELECT COUNT(*) FROM syscolumns s WHERE s.id = OBJECT_ID('table_name');

根据列名查找表

SELECT name
FROM ScoreData_XiongAn_TY.[dbo].sysobjects
WHERE id IN (
                SELECT id
                FROM ScoreData_XiongAn_TY.[dbo].syscolumns
                WHERE name LIKE '%mac%'
            );