I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-05

173 reads

Blogs

Over the past few months, I have debated starting a new blog to discuss...

It’s that time of the month again, and once again, I’m late and I’m...

This is from 2010, but I loved that people felt this way about Redgate...

Forums

hi, need to known weather fast farwand cursor is faster than a while loop...

Comments posted to this topic are about the item Economics of AI: What is...

Comments posted to this topic are about the item Poor Name Choice

I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?

SELECT   
    INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail')