You cannot change a character column to numeric and vice versa. To change a column's data type, drop the column and then add it (and its data) again, or use the DATA step. Note: You cannot change the ...

I'm trying to create a new database diagram in SQL Server so that I can refer to it for relationships and that sort of thing. I opened SQL Server Enterprise Manager, created a new diagram, added ...