Remi,

I am populating a DataGrid in VB .NET using a query.  I thought it would be nice to have a column with a row number, just like you get in...

I am just trying to dynamically number the rows in a query without using IDENTITY (which makes me recreate the table).

Mark

Ray,

You are right in that the article you quoted shows how to dynamically rank rows.  That is what I want to do.

However, I have read that article before and unfortunately that...

Thanks to all.  This query works great!

select column_name from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

where table_name = 'TableName' and constraint_name like 'PK%'

What does HTH mean?

Mark

Sorry sushila!  You are right!  My fault.

The test database I am working with has no primary keys in any tables.  When I used your query with another database, I can...

I appreciate the kind replies to my question.  Unfortunately neither one seems to help.  I have no rows in my sysobjects table that have an xtype beginning with 'PK'.  I...