[dba-SQLServer] SQL Documenter

Look at the system table, sysobjects, in the database in question.
User tables have xtype='U'.

On 6/1/06, Robert L. Stewart <rl_stewart at highstream.net> wrote:
> You can also use the system tables to generate the list for you.
>
> Robert L. Stewart
> The Dyson Group International
> Software for the Non-profit Enterprise
> Expanding your Sphere of Knowledge
>
>
> Quoting dba-sqlserver-request at databaseadvisors.com:
>
> > From: paul.hartland at fsmail.net
> > Subject: [dba-SQLServer] SQL Documenter
> > To: dba-sqlserver <dba-sqlserver at databaseadvisors.com>
> > Message-ID: <18582123.1149152410208.JavaMail.www at wwinf3203>
> > Content-Type: text/plain; charset=UTF-8
> >
> > To all,
> > Is there a (hopefully freebie) tool somewhere where I can list all tables etc
> > inside a SQL database.
> > Thanks in advance.
> > Paul Hartland
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>