Hi Diane,
You can use DataTools (download #
12963) to create metadata and then to export datadict table to excel. Just remember that memo fields are not exported to Excel, so you would need to convert them to character fields.
>Hi,
>
>I have a SQL database without any documentation. I want to create a document like an excel spreadsheet to list each table and their field definition (name, lenght, default value).
>
>Any idea how I can do that?
>
>TIA
>Diane Robitaille
Venelina Jordanova
Outsourcing IT Services Ltd.