SELECT Count(COLUMN_NAME)FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'TableName' AND TABLE_SCHEMA = 'DatabaseName'
SELECT Count(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TableName' AND TABLE_SCHEMA = 'DatabaseName'
我试着从一张table上取数。如何使用多个超过10k的表来实现这一点
fwzugrvs1#
删除表名的过滤条件，如下所示
SELECT Count(COLUMN_NAME)FROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_SCHEMA = 'DatabaseName'
WHERE TABLE_SCHEMA = 'DatabaseName'
1条答案
按热度按时间fwzugrvs1#
删除表名的过滤条件，如下所示