Advanced Search

Return to Snippet

Revision: 22072
at December 31, 2009 10:49 by CDIDevs
Initial Code 
/*
Date:			2009-12-08
Resource URL:		http://snippets.dzone.com/posts/show/2035
Purpose:		Search DB for column name 
*/ 

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like 'productid%' ) order by name
Initial URL 
http://snippets.dzone.com/posts/show/2035
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Search Database for Column Name

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, search

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL