tahaipek/MSSQLFindTableName.sql

Created March 11, 2016 15:47

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/tahaipek/6bad40f4dde5f2a713d3.js"></script>
Save tahaipek/6bad40f4dde5f2a713d3 to your computer and use it in GitHub Desktop.

Download ZIP

MSSQL Find Table Name

Raw

MSSQLFindTableName.sql

	USE [TESTDB]
	GO
	SELECT t.name, SCHEMA_NAME(schema_id) AS schema_name FROM sys.tables AS t WHERE t.name like '%Test%'

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