How to Change DataType of TimeStamp Column.
Datatype of Timestamp column cannot be deleted. Hence it is advised to drop the column and re-create it
For example,
ALTER TABLE [dbo].[PerformanceMaster] DROP COLUMN PerformanceDate
ALTER TABLE [dbo].[PerformanceMaster] ADD PerformanceDate datetime2
Showing posts with label Change DataType of TimeStamp Column. Show all posts
Showing posts with label Change DataType of TimeStamp Column. Show all posts
Monday, February 21, 2011
Subscribe to:
Posts (Atom)
