Skip to content

Instantly share code, notes, and snippets.

@tahaipek

tahaipek/MSSQLFindTableName.sql

Created March 11, 2016 15:47
Show Gist options
  • Save tahaipek/6bad40f4dde5f2a713d3 to your computer and use it in GitHub Desktop.
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