get a list of fields contained in a table? 2

[jgoodman00]

Is there a way of doing this, because I want to get a complete list of fields from each table, & then print them out... James Goodman

 

[cbokowski]

Watch for wrap.

http://www.planetsourcecode.com/xq/ASP/txtCodeId.248/lngWId.5/qx/vb/scripts/ShowCode.htm

SQL Statement that will list all the tables, columns, and datatypes in a Database alphabetically

 

[tlbroadbent]

In SQL 7 and 2000 you can use the built-in INFORMATION_SCHEMA views.

Select * From INFORMATION_SCHEMA.Columns will provide a list of all columns in the current database. You can order the list in way you wish. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.