InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 10:14:14 GMT20http://www.sqlservercentral.com/Forums/Topic405308-636-1.aspxI found this very useful. I am constantly looking for a particular element name.I took some liberties and enhanced my version of the code to look across all database on the server; using a cursor to store db names.My code enhancement is shown below.Arnie StewartDECLARE @DB AS VARCHAR(25)DECLARE @CNT AS INTDECLARE @SQL NVARCHAR(4000)DECLARE @vcColumnName varchar(100) ----SET @vcColumnName = 'PAT_NM'----DECLARE C1_CURSOR SCROLL CURSOR FOR SELECT NAME AS DBFROM MASTER.dbo.sysdatabasesWHERE NAME NOT LIKE 'MASTER' ANDNAME NOT LIKE 'TEMPDB' ANDNAME NOT LIKE 'MODEL' ANDNAME NOT LIKE 'MSDB'ORDER BY NAMETRUNCATE TABLE ADHOC.DBO.TBL_IT_COLUMNS_DBASE_LOOKUPSET @CNT = 0OPEN C1_CURSORFETCH NEXTFROM C1_CURSORINTO @DBWHILE @@FETCH_STATUS = 0 BEGIN SET @SQL='INSERT INTO ADHOC.DBO.TBL_IT_COLUMNS_DBASE_LOOKUP SELECT DISTINCT ''' + @DB + '''AS DBASE, SUBSTRING(o.NAME,1,60) AS [Table Name] FROM ' +@DB+'.dbo.sysobjects o INNER JOIN ' +@DB+'.dbo.syscolumns c ON o.ID = c.ID WHERE c.name = ''' + @vcColumnName + ''' AND o.XTYPE = ''U'' ORDER BY [Table Name]' EXEC(@SQL) FETCH NEXT FROM C1_CURSOR INTO @DB ENDCLOSE C1_CURSORDEALLOCATE C1_CURSORSELECT * FROM ADHOC.DBO.TBL_IT_COLUMNS_DBASE_LOOKUPMon, 22 Oct 2007 10:01:53 GMTArnie Stewarthttp://www.sqlservercentral.com/Forums/Topic405308-636-1.aspxThanks for the tip!Wed, 10 Oct 2007 13:25:19 GMTkgaydahttp://www.sqlservercentral.com/Forums/Topic405308-636-1.aspxTry this for a trick: use Excel/MS Query to open INFORMATION_SCHEMA.COLUMNS then use Autofilter to create a simple data dictionary tool that does something very similar to your script.Mon, 08 Oct 2007 09:05:35 GMTAndrew_Websterhttp://www.sqlservercentral.com/Forums/Topic405308-636-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31964/">Find Column Name Usage</A>[/B]Mon, 01 Oct 2007 16:32:13 GMTkgayda