CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Learning
Learning

Reputation: 20001

Change Date column to DateTime in SQL Server

I have to change the EventDate column data type from Date to Datetime. When I tried to do it, it failed to save the change with message

Saving changes is not permitted. The changes you have made require the following table to be dropped & recreated. ....

Is there a way that it can be don't with dropping the table? If I drop the table then I will have another issue to deal with when I importing the data as EventID is based on auto increment & ID can't be changed.

Any solution to this issue in SQL Server 2008 ?

Upvotes: 3

Views: 4528

Answers (1)

Pரதீப்
Pரதீப்

Reputation: 93694

The following steps should help you.

To change this option,

  1. Tools menu
  2. click Options
  3. Designers
  4. Select Table and Database Designers
  5. Clear the check box Prevent saving changes that require the table to be re-created.

Upvotes: 4

Related Questions