Advanced Search

Return to Snippet

Revision: 27774
at June 23, 2010 05:08 by ezerick
Initial Code 
SELECT tab.name as TableName, col.name as ColumnName
FROM sys.tables AS tab
JOIN sys.columns AS col ON tab.object_id = col.object_id
ORDER BY tab.name, col.name
Initial URL 
http://snipplr.com/developer/
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL Server 2005 - All Cols in all Tables in a DB

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL