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 |
|
vogjer12851
Starting Member
2 Posts |
 Posted - 2009-05-18 : 10:50:26
|
| Dear All,I try to find a solution to change the field definition in my different tables of my database.I have to migrate a database and the custom DataType was created in the dbo schema.I have 100 table and 500 fields affected by this change.Thank you for your help !edit: moved to proper forum |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-05-18 : 14:53:28
|
| Are you trying to change the datatype of multiple columns in several tables? If so, what are your current column datatypes and what are you trying to change them to?Some days you're the dog, and some days you're the fire hydrant. |
 |
|
|
vogjer12851
Starting Member
2 Posts |
Posted - 2009-05-19 : 01:55:52
|
| Hello,Yes, it's exactelly what I try.The field are defined for example : ID dbo.PrimaryKey (Varchar32)And I have to pass this column as : ID appl.PrimaryKey.I have 5 different datatype define.Thank you for your help |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-19 : 11:01:27
|
| do you have any constraints defined on column? if yes, you need to drop them before alering column using ALTER TABLE tablename ALTER COLUMN columnname... |
|
|
|
|
|
|
Data Type Definition