Nisden/CountLineBreaksInAllSQLObject.sql

Created April 8, 2014 14:13

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

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

Download ZIP

Raw

CountLineBreaksInAllSQLObject.sql

select sys.objects.name, sys.objects.type_desc, LEN(OBJECT_DEFINITION(object_id)) - LEN(REPLACE(OBJECT_DEFINITION(object_id), CHAR(13)+CHAR(10), ' ')) +1 as lines from sys.objects where is_ms_shipped = 0 AND OBJECT_DEFINITION(object_id) IS NOT NULL order by lines DESC

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