Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joseph1975
Starting Member
6 Posts |
 Posted - 2012-02-03 : 11:57:38
|
| I have modified a coloumn inside a table from numeric to money. When we run the query the data type is still numeric. I need to close and open the SQL server management studio to get the update. Why is this. How can we get the update without closing |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-03 : 12:03:27
|
are you speaking about intellisense in ssms? if yes, it sometimes does not pick up changes in datatype done through same connection. You dont need to be worried on that as table would have changed datatype of column already its just intellisense not showing ityou can check it as followsSELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME=<the column name> AND TABLE_NAME =<the table name> ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
joseph1975
Starting Member
6 Posts |
Posted - 2012-02-03 : 12:13:28
|
| Thanks. That helps |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-03 : 12:16:10
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Not getting refreshed