Re: Exporting table/field names

Tech-Archive recommends: Fix windows errors by optimizing your registry

How about something like: -

select table_name
, column_name
, ordinal_position
, data_type
from information_schma.columns
order by table_name
, ordinal_position

"M. Grass" <M. Grass@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5F6DBD09-83AE-4A94-AA73-A99C9EAB2812@xxxxxxxxxxxxxxxx
> Hi,
>
> I am managing a large database--several hundred tables. The current system
> I inherited employs an Excel spread*** to manage the details
> (description,
> business rules, etc) of the tables and fields. We would like to convert
> the
> information in this spread*** to a more convenient Access database;
> however, the information in the spread*** has unfortunately not been
> maintained with the development of the database.
>
> To seed the new Access dictionary database, I would like to get a dump of
> all tables and associated field names from SQL Server. Conveniently, the
> dump
> would be in a format similar to:
> TableName1 TableName2 ...
> FieldName1.1 FieldName2.1
> FieldName1.2 FieldName2.2
> FieldName1.3 ...
> ...
>
> I don't really care what the fields are exported as, CSV, xls, whatever. I
> would just prefer to copy these to the new Access data dictionary rather
> than
> type them in manually.
>
> Any ideas?
>
> --Mike


.

Quantcast