Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

Generating color from list by input string

Rathnakar

I have a list of 5 colors in an array ['#fff', '#000', '#cacaca', '#c0c0c0', '#eaeaea'] and I have any input string. How to select a color from a list by string seed?

For example: I want to get the color from this string "MyNameIsMarty" and the color from the list should always be the same for this string.

I read a lot about seeds, but there is no answer for my question.