Posted By

lance on 08/05/10


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


List all tables and fields in database

 / Published in: SQL

  1. --list all tables and fields in a database
  2. SELECT AS TableName, AS FieldName,
  3. syscolumns.colorder AS FldOrder
  4. FROM sysobjects INNER JOIN syscolumns ON =
  5. WHERE sysobjects.type = 'U'
  6. ORDER BY, syscolumns.colorder

Report this snippet  

You need to login to post a comment.