To count number of rows in SQL table
snippet in sql

To count number of rows in SQL table

user1001

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';

how to count number of rows in sql

user1931

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;