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