Set The Ordinal Position Of Column

Arun Kumar

10y1.6kCode

This code snippet shows how to Set the ordinal position of Column.

UPDATE information_schema.columns SET ORDINAL_POSITION = 4 WHERE table_name = 'lkpGrassHeight' AND table_schema = 'dbo' AND column_name = 'SequenceNo'