Microsoft Most Valuable Professional

Chris Pietschmann

An MVP From Wisconsin

Home Archive Contact Subscribe Sign in

<< CHRIS CHRISTMAS RODRIGUEZ | AntiMatter is a reality: not just for Trekkies! >>

SQL Script: Search all tables for a specific field

DECLARE @NAME_TO_SEARCH_FOR nvarchar(50)

SET @NAME_TO_SEARCH_FOR = '%photo%'

SELECT sysobjects.name AS Table_Name, syscolumns.name AS Column_Name
FROM syscolumns INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE syscolumns.name LIKE @NAME_TO_SEARCH_FOR AND sysobjects.Type Like 'U%'

Currently rated 5.0 by 2 people

Currently 5/5 Stars.
1
2
3
4
5

Categories: General

Posted by crpietschmann on Friday, October 29, 2004 12:36 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (0) | Post RSS RSS comment feed

RSS comment feed

Related posts

T-SQL: Join Tables by a Field that contains a delimited stringJavaScript: Add Search Engine Keyword Highlight Support to your site with easeReal Estate - The Search That Should Be.

Comments are closed

About the author

I'm Chris Pietschmann, go to the About Me page to learn more about me.

Send mail

Search

Sponsors

Web.Maps.VE - ASP.NET AJAX Virtual Earth Mapping Server Control

Recent posts

Less Than 36 Hours Left to Enter the Community Coding Contest!Comments: 0Rating: 0 / 0
Virtual Earth 6.2 JavaScript Intellisense Helper ReleasedComments: 0Rating: 0 / 0
Silverlight Isolated Storage File/Directory LocationComments: 0Rating: 0 / 0
Windows vNext (Windows 7?) Feature IdeasComments: 2Rating: 0 / 0
Custom Themes in ASP.NET MVC Updated for Preview 5Comments: 0Rating: 3.5 / 2
.NET 3.5 SP1: DataContractJsonSerializer BugComments: 4Rating: 0 / 0
CouchDB on FLOSS Weekly Episode 36 - distributed, document-oriented, RESTful databaseComments: 1Rating: 0 / 0
How To Setup Custom Theme Support In ASP.NET MVC Preview 4 using a Custom ViewEngineComments: 3Rating: 5 / 1
How To Use ASP.NET MVC in Website rather than Web Application ProjectComments: 2Rating: 5 / 3
8/11/2008 - My email is currently downComments: 1Rating: 5 / 1

Recent comments

Windows vNext (Windows 7?) Feature Ideas (2)
Jarrett wrote: Yea, they should take some hints from Google Chrom… [More]
How To Setup Custom Theme Support In ASP.NET MVC Preview 4 using a Custom ViewEngine (3)
Jarrett wrote: Woops, I'm blind, http://pietschsoft.com/post/2008… [More]
How To Setup Custom Theme Support In ASP.NET MVC Preview 4 using a Custom ViewEngine (3)
Jarrett wrote: Nice post! I think this changed a good bit with t… [More]
.NET 3.5 SP1: DataContractJsonSerializer Bug (4)
crpietschmann wrote: After too long, I finally tried uninstalling SP1 a… [More]
Virtual Earth: Polygon Search - Is Point Within Polygon? (1)
vishal wrote: Hi, i found my answer it is very simple dim … [More]
Windows vNext (Windows 7?) Feature Ideas (2)
Chris Pietschmann wrote: I just thought of another idea... [b]11) Be able … [More]
C#: Generate WebPage Thumbmail Screenshot Image (12)
Somdutta Roy wrote: Wow, this article is a great one, i was always a n… [More]
C#: Generate WebPage Thumbmail Screenshot Image (12)
amrelgarhy wrote: When i give it this URL http://www.yahoo.com its n… [More]
C#: Generate WebPage Thumbmail Screenshot Image (12)
Chris Pietschmann wrote: The code in this post doesn't open a browser windo… [More]
C#: Generate WebPage Thumbmail Screenshot Image (12)
Patric wrote: Hi, Is there any way to capture the browser windo… [More]

Authors

crpietschmann (374)

Categories

Disclaimer

This work is licensed under a Creative Commons Attribution 3.0 United States License, unless explicitly stated otherwise within the posted content.
© Copyright 2004 - 2008 Chris Pietschmann