[dba-SQLServer] All tables, columns and indexes

I would be interested in learning that from you.  I have only been able to
accommodate comma-delimited strings of a column through a function, so if I
can get around having to build a function to do it, I would definitely be
happy.

Ken

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Monday, August 04, 2008 3:26 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] All tables, columns and indexes

Very nice. Now I just have to dig my notes on Coalesce so I can
comma-delimit the indexed columns for each index rather than get multiple
rows, but not should not be difficult.

Thanks!

On Mon, Aug 4, 2008 at 4:20 PM, kens.programming <
kens.programming at verizon.net> wrote:

> Arthur,
>
> Is something like this what you are looking for?:
>
> SELECT so.name, si.name, sc.name
> FROM sysobjects so INNER JOIN sysindexes si ON so.id = si.id
>        INNER JOIN sysindexkeys sik ON si.indid = sik.indid AND so.id =
> sik.id
>        INNER JOIN syscolumns sc ON sik.colid = sc.colid AND so.id = sc.id
> WHERE so.type = 'U'
>
> Ken
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 270.5.12/1590 - Release Date: 8/4/2008
8:09 AM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 270.5.12/1590 - Release Date: 8/4/2008
8:09 AM