mikaelweave/SQL find table by name.sql

Created March 19, 2015 23:03

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/mikaelweave/4da27d4ff7f3e4cbd73a.js"></script>
Save mikaelweave/4da27d4ff7f3e4cbd73a to your computer and use it in GitHub Desktop.

Download ZIP

Scan all SQL tables in a database by name

Raw

SQL find table by name.sql


	SELECT
	name
	FROM
	ices.sys.tables
	WHERE
	name LIKE '%Line%'
	AND is_ms_shipped = 0;

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