• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Adding a timestamp column to a SQL table.

Is there a recommendation on whether to add a timestamp column on the beginning or end of the table?
Does it matter where the column is added.

0
vasudharangapathy
Asked:
vasudharangapathy
2 Solutions
 
mbizupCommented:
>Does it matter where the column is added.
The order doesn't matter.  I keep timestamp, created by and modified by information in the last columns of my table-- just for consistency's sake.
0
 
CraigDeringtonCommented:
I concur, all date/time/user stamps are usually placed in the last few columns of a table.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now