update information_schema.columns

anushahanna
anushahanna used Ask the Experts™
on
can you update information_schema.columns? (specifically ordinal_position)

thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
No, you can't update this System views..

In order to update Ordinal position, you have drop the table and recreate it with the specific order..

Author

Commented:
OK. thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial