• Home
  • Info
Search

Web development and technologies | egeek

ASP.NET, C#, Azure, SQL, Server, Umbraco, Sitecore, Git and other stuff I find useful

All Posts Tagged SQL

SQL find all tables where column name =

By Paul on August 4, 2014Leave a Reply

This is a fast and simple way to find all tables in a SQL database which contains a specific column.

[sql]
SELECT COLUMN_NAME, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE ‘%MyColumn%’
[/sql]

Posted in: Server SQL ServerTagged: SQL

Subscribe to egeek.io

Subscribe to egeek.io and receive notifications of new blog posts by email

Recent posts

  • Disable overwrite in Sublime Text June 20, 2016
  • Umbraco Codegarden 2016 June 15, 2016
  • ASP.NET Core and .NET Core Overview June 9, 2016
  • Mobile website speed test tools June 4, 2016
  • Change domain name WordPress, the SEO friendly way June 4, 2016

Categories

  • CMS
    • DynamicWeb
    • Sitecore
    • Umbraco
    • Wordpress
  • Desktop
    • Mac
    • Windows
  • Development
    • Git
    • Hacks and stuff
    • JavaScript
    • Microsoft
  • Misc
  • SEO
  • Server
    • Apache
    • IIS
    • MySQL
    • Node.js
    • SQL Server
    • Windows
    • Windows Azure

Tags

.NET.CORE Active Directory analytics Apache Apple ASP.NET ASP.NET CORE Azure C# DNS Git IIS Lucene mysql Node.js OS X PowerShell regex Ruby on Rails search console SEO Solr SQL SQL Server terminal Tomcat Url Rewrite Visual Studio wcf Windows Windows Azure Windows Forms Windows Server Wordpress
COPYRIGHT © 2016 EGEEK.DK. ALL RIGHTS RESERVED. Back to the top