Sunday, February 12, 2012

Can I move some column position by using SQL command ?

I created SQL table follow by XSD file

And when any users added new column to XSD in ordinal position = 3

But after my program successfully created new column, its position is the last position

What can I do ??

I suspect why I can't set it (I've looked for solution on MSDN already)

even though

We can see ordinal position by

this query

SELECT *
FROM INFORMATION_SCHEMA.Columns

What can I do for solving ?? Help me please

You're adding columns dynamically? They will go to the end and I'd be surprised if there was any way to change the position.

But more importantly, why are you adding columns dynamically and why do you care what position the columns are in? It makes no difference what the physical col position is in a table

No comments:

Post a Comment