Forum Replies Created

Viewing 3 posts - 841 through 844 (of 844 total)

  • RE: SQL 2005 - List Primary Key Columns

    It could be either your table does not have an index set up, or the database doesn't have any tables that have indexes.

    You need to be connected to...

  • RE: SQL 2005 - List Primary Key Columns

    Here is a query to find all the indexes on a table.

    select r.[name] as table_name, i.[name] as index_name, c.[name] as column_name

    FROM sys.index_columns l

    inner join sys.tables r on

    l.object_id = r.object_id

    inner join...

  • RE: SQL 2005 - List Primary Key Columns

    I like the ides of this, I would add ordering the columns as they are defined in the key. And for the programmers in my area I would add...

Viewing 3 posts - 841 through 844 (of 844 total)