Find a Column, Find a Table in SQL Server
OK, so this isn’t rocket science, but then again some of the best things are the simplest. You can do a lot with the information_schema views in SQL Server. Here is a short stored procedure that you can use to find: * a table by its full name * a table by partial name * a column by its full