If you are trying to find a table or a view based on a column name here is a piece of code that will be very helpful to you.
\nYou will get the following:
\n1) full column name
\n2) object name (including schema)
\n3) object type (table\/view)
\n4) data type (nice format: varchar(6) or numeric(5,2), etc.)
\n5) null\/not null
\n6) information on identity, check constraint, and default info<\/p>\n
\nDECLARE @Search varchar(200)
\nSET @Search=’YourColumnName’ –can be a partial or a complete name<\/p>\nSELECT
\n s.name as ColumnName
\n ,sh.name+’.’+o.name AS ObjectName
\n ,o.type_desc AS ObjectType
\n ,CASE
\n WHEN t.name IN (‘char’,’varchar’) THEN t.name+'(‘+CASE WHEN s.max_length<0 then 'MAX' ELSE CONVERT(varchar(10),s.max_length) END+')'\n WHEN t.name IN ('nvarchar','nchar') THEN t.name+'('+CASE WHEN s.max_length<0 then 'MAX' ELSE CONVERT(varchar(10),s.max_length\/2) END+')'\n WHEN t.name IN ('numeric') THEN t.name+'('+CONVERT(varchar(10),s.precision)+','+CONVERT(varchar(10),s.scale)+')'\n ELSE t.name\n END AS DataType\n\n ,CASE\n WHEN s.is_nullable=1 THEN 'NULL'\n ELSE 'NOT NULL'\n END AS Nullable\n ,CASE\n WHEN ic.column_id IS NULL THEN ''\n ELSE ' identity('+ISNULL(CONVERT(varchar(10),ic.seed_value),'') + ',' + ISNULL(CONVERT(varchar(10),ic.increment_value),'') +') = '+ ISNULL(CONVERT(varchar(10),ic.last_value),'null')\n END\n +CASE\n WHEN sc.column_id IS NULL THEN ''\n ELSE ' computed('+ISNULL(sc.definition,'')+')'\n END\n +CASE\n WHEN cc.object_id IS NULL THEN ''\n ELSE ' check('+ISNULL(cc.definition,'')+')'\n END\n AS MiscInfo\n FROM sys.columns s\n INNER JOIN sys.types t ON s.system_type_id=t.system_type_id and t.is_user_defined=0\n INNER JOIN sys.objects o ON s.object_id=o.object_id\n INNER JOIN sys.schemas sh on o.schema_id=sh.schema_id\n LEFT OUTER JOIN sys.identity_columns ic ON s.object_id=ic.object_id AND s.column_id=ic.column_id\n LEFT OUTER JOIN sys.computed_columns sc ON s.object_id=sc.object_id AND s.column_id=sc.column_id\n LEFT OUTER JOIN sys.check_constraints cc ON s.object_id=cc.parent_object_id AND s.column_id=cc.parent_column_id\n WHERE s.name LIKE '%'+@Search+'%'\n<\/p><\/blockquote>\nh\/t KM.<\/a>
\nsource<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"If you are trying to find a table or a view based on a column name here is a piece of code that will be…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,12],"tags":[61,79,21,166,165,50,78,49],"class_list":["post-441705","post","type-post","status-publish","format-standard","hentry","category-how_to","category-sql","tag-column","tag-microsoft","tag-ms","tag-name","tag-search","tag-sql-2","tag-sql2008","tag-tsql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/441705"}],"collection":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/comments?post=441705"}],"version-history":[{"count":8,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/441705\/revisions"}],"predecessor-version":[{"id":671887,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/posts\/441705\/revisions\/671887"}],"wp:attachment":[{"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/media?parent=441705"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/categories?post=441705"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mkncreations.com\/site\/wp-json\/wp\/v2\/tags?post=441705"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}