xxxxxxxxxx
SELECT COUNT(*)
FROM dbo.bigTransactionHistory;
xxxxxxxxxx
SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';
xxxxxxxxxx
#The COUNT() function returns the number of rows that match specific characteristics.
SELECT
COUNT(*)
FROM
database_name.table_name