anibihakeem/SCHEMA_COUNT Secret

Created December 11, 2023 12:42

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/anibihakeem/38fa0bbb2ef12d02843f2bd7e6897c09.js"></script>
Save anibihakeem/38fa0bbb2ef12d02843f2bd7e6897c09 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

SCHEMA_COUNT

	SELECT DISTINCT TABLE_SCHEMA, COUNT(TABLE_NAME) AS table_count
	FROM AdventureWorks2022.INFORMATION_SCHEMA.TABLES
	GROUP BY TABLE_SCHEMA

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment