Before you really start your project, it’s not a bad idea to right click on the table in SSMS to bring up a CREATE TABLE script, then re-order all of the fields. Aware jumbles them up in no discernible order. But later on, if you open your table up to an external reporting tool, someone Will think you’re an idiot for creating the fields in the order that you did, even though you didn’t really do it.
Always been a pet peeve of mine.
Most integers don’t need to be bigint.
1 char field doesn’t need to be varchar(1).
If you need seconds in a time stamp u have to change it.
After the initial ordering, any new fields you add will be added to the end. And you can live with that usually.
It’s just a minor inconvenience, and within an hour you can usually sort it all out.
to see a collection of my tips & hacks on this forum? Or search for "JaymerTip" in the search bar at the top.
Aware Programming & Consulting - Tampa FL