Posted by SQL Enthusiast
Article by our editor
To get the number of rows in a single table we usually use SELECT COUNT(*) or SELECT COUNT_BIG(*). This is quite straightforward for a single table, but quickly gets tedious if there are a lot of tables, and also can be slow. Here are a few ways of listing all the tables that exist in a database together with the number of rows they contain.
Comments (8) • Read full article »
This SQL script creates a comma separated list of all columns in a table. This can be useful for creating SQL INSERT and SELECT statements etc.
Comments (2) • Read full article »
More SQL questions »
© 2010 - 2017. All Rights Reserved. Design by