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……
Source: http://www.sqljason.com/2010/06/display-total-on-top-of-stacked-chart_8589.html It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog……
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME=’table_name’ and COLUMN_NAME in (‘column_name’,’column_name2′) OR SELECT ORDINAL_POSITION ,COLUMN_NAME ,DATA_TYPE ,CHARACTER_MAXIMUM_LENGTH ,IS_NULLABLE ,COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘youtablename’ ORDER……