我想知道是否有可能找到一个表中的行数和列数。
SELECT COUNT(*)
FROM tablename
发布于 2009-03-18 14:12:31
SELECT COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_catalog = 'database_name' -- the database
AND table_name = 'table_name'
发布于 2014-07-25 18:42:52
SELECT COUNT(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_CATALOG = 'Database name'
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'table name'
发布于 2017-01-30 15:40:01
SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_name';
注意: Your_table_name应该替换为您的实际表名
https://stackoverflow.com/questions/658395
复制相似问题