Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is timestamp_column?
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01278358
Message ID:
01278360
Views:
20
>It looks like each one of the tables of my SQl Server database has a column timestamp_column of type timestamp. I don't remember adding this column. How could it have gotten there?
>
>Also, the Insert into a table fails pointing that Default should be used when inserting to timestamp_column. How do you do it?
>
>Thank you in advance.
>
>UPDATE: I found that not all tables have this column but a lot of them. Could this column been added by VFP wizard that converted VFP database to SQL Server? Is it then ok to delete this column?

Here is a link to the M$ docs : http://msdn2.microsoft.com/en-us/library/aa260631(SQL.80).aspx
The timestamp column is updated automatically on insert and update. This data type is usually used to version stamp a record. I am unsure how this collumn got added if you didn't do it.

Einar
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform