Advanced Search

Return to Snippet

Revision: 29921
at August 5, 2010 05:34 by lance
Initial Code 
--list all tables and fields in a database
select sysobjects.name as TableName, syscolumns.name as FieldName, 
syscolumns.colorder as FldOrder 
from sysobjects inner join syscolumns on syscolumns.id = sysobjects.id 
where sysobjects.type = 'U'
order by sysobjects.name, syscolumns.colorder
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
List all tables and fields in database

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL