moving column in sql
-
how to moving column in sql ? by code ?
-
how to moving column in sql ? by code ?
Which database? MS SQL server from 2005 on - can't be done anymore. They took the ability out. Other databases...don't know...but a Google for ALTER COLUMN ORDER might bring some up.
Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life. My Mu[sic] My Films My Windows Programs, etc.
-
how to moving column in sql ? by code ?
What do you mean "move"? Do you mean move it from one table to another? Or change the order in which the column appears in a query result set? Or change the order in which the column is defined in the table?
-
how to moving column in sql ? by code ?
Try this SQL SERVER – Change Order of Column In Database Tables[^]
thatraja
**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
** -
What do you mean "move"? Do you mean move it from one table to another? Or change the order in which the column appears in a query result set? Or change the order in which the column is defined in the table?
Hi Thank you for the answer In your table, not the other table I mean, is the priority fields
-
Try this SQL SERVER – Change Order of Column In Database Tables[^]
thatraja
**My Tip/Tricks
My Dad had a Heart Attack on this day so don't...
**What this command do? EXEC sp_rename @objname = ‘test.col3_new’, @newname = ‘col3′, @objtype = ‘COLUMN’ Whether the priorities are changed? This will only change the name? But I want to change priority Thanks!
-
What this command do? EXEC sp_rename @objname = ‘test.col3_new’, @newname = ‘col3′, @objtype = ‘COLUMN’ Whether the priorities are changed? This will only change the name? But I want to change priority Thanks!
What do you mean by change priority? Do you mean you want to affect how the result is ordered (in other words, how it is sorted)?
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility