SQL Database Reporting?

[jchastai]

When I was using Access databases, you could have access generate a report on a database that would basically list any tables/queries/forms/etc. and all of their parameters.

I used this quite frequently to get a listing of all of my tables and their associated fields/types/etc.

One of my servers recently coverted to SQL 2000, but I cannot find a way to get the reports. Does anybody know how to do such a thing with an SQL 2000 DB?

Thanks
Jeff Chastain

 

[Bernadette]

Hi There

If you run the following in Query Analyser

Exec sp_help mytablename

You will get a list of fields, types, indexes, keys etc for your table.

Hope This Helps


Bernadette