The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double

by

Try this:

Remove the constraint DF_Movies_Rating__48CFD27E before changing your field type.

The constraint is typically created automatically by the DBMS (SQL Server).

To see the constraint associated with the table, expand the table attributes in Object explorer, followed by the category Constraints as shown below:

Tree of your table

You must remove the constraint before changing the field type.

More Related Contents:

  1. Solution for: Store update, insert, or delete statement affected an unexpected number of rows (0) [closed]
  2. How can I schedule a job to run a SQL query daily?
  3. What’s the best practice for primary keys in tables? [closed]
  4. Reset identity seed after deleting records in SQL Server
  5. How to create multiple one to one’s
  6. How to Create a real one-to-one relationship in SQL Server
  7. Generate a resultset of incrementing dates in TSQL
  8. T-SQL Cast versus Convert
  9. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  10. How Can I use “Date” Datatype in sql server?
  11. How would you implement sequences in Microsoft SQL Server?
  12. What does =* mean?
  13. Correct use of transactions in SQL Server
  14. Splitting the string in sql server
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. How can I do a BEFORE UPDATED trigger with sql server?
  17. Favourite performance tuning tricks [closed]
  18. Deferrable Constraints in SQL Server
  19. How to check which locks are held on a table
  20. How to sum up time field in SQL Server
  21. Know relationships between all the tables of database in SQL Server
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. Using SQL Server as a DB queue with multiple clients
  24. Suggestions for implementing audit tables in SQL Server?
  25. SQL Server search using like while ignoring blank spaces
  26. What does ON [PRIMARY] mean?
  27. How do I list all the columns in a table?
  28. How do I change db schema to dbo
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. Space used by nulls in database

Leave a Comment