how to know the size of table in sql server code example

Example: check size of table sql

SELECT pg_size_pretty( pg_total_relation_size('tablename') );
(postgres)