Return to Snippet

Revision: 29921
at August 5, 2010 05:34 by lance

Initial Code
--list all tables and fields in a database
select as TableName, as FieldName, 
syscolumns.colorder as FldOrder 
from sysobjects inner join syscolumns on = 
where sysobjects.type = 'U'
order by, syscolumns.colorder

Initial URL

Initial Description

Initial Title
List all tables and fields in database

Initial Tags

Initial Language