"rodchar" <rodc***@discussions.microsoft.com> wrote in message
news:1403F2CC-A928-4E0B-868E-F70029D16DCD@microsoft.com...
> hey all,
> what's the best way to get a report of all tables in the database and
> their
> properties? to fit on one page if can.
>
> thanks,
> rodchar

"Tom Cooper" wrote:

> What properties do you want?  For example, you could run
>
> select 'exec sp_help [' + name +']' from sysobjects where type = 'U'
>
> then take the output of that and run it as a query.  It will return lots of
> properties about all your tables, but it's not gonna fit on one page for any
> realistic database.
>
> Tom
>
> "rodchar" <rodc***@discussions.microsoft.com> wrote in message
> news:1403F2CC-A928-4E0B-868E-F70029D16DCD@microsoft.com...
> > hey all,
> > what's the best way to get a report of all tables in the database and
> > their
> > properties? to fit on one page if can.
> >
> > thanks,
> > rodchar
>
>
>