Rank: Newbie
Groups: Member
Joined: 11/7/2006
Posts: 1
Points: 0
Location: New Zealand
|
Hi,
Wondering if the tool is possible in modifying column name and order within tables.
I have full version of mylittleadmin which I thought that it should have at least some of the advance features within SQL Server Management Studio like when modifying tables.
Please let me know if it is possible and if there is anything that needs to be turned on thanks.
Regards
Edmund
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Hi
No. This is not possible.
The physical column order should only be significant when you use SELECT statement and SELECT * statement can be considered like a bad programming statement. Order the columns in your SELECT statement or alternatively create a view over the table.
If ever you must change the order, then the only solution is to create a new table and populate it from the original. Keep in mind that you'll need to disable/enable all constraints, recreate all indexes, re-compute all views/sp/functions that depend on your table and of course copy the whole amount of data (which could take a while if the table contains thousands of rows). This is what SSMS does...
Best regards
|