how to write a query change the datatype for primary key coulm in atable using sqlserver 2008.
-
how to write a query change the datatype for primary key coulm in atable using sqlserver 2008. Thnaks In advance Ch.Gayatri
-
how to write a query change the datatype for primary key coulm in atable using sqlserver 2008. Thnaks In advance Ch.Gayatri
use
ALTER TABLE, you might also consider this[^].Never underestimate the power of human stupidity RAH
-
use
ALTER TABLE, you might also consider this[^].Never underestimate the power of human stupidity RAH
i tired but its did not worked ou becoz my primary key is used as Fkey in so many tables.
-
i tired but its did not worked ou becoz my primary key is used as Fkey in so many tables.
Then you have a serious design problem, what are the data type changes you want to affect? You could do this right by: Identify and drop all the FK referencing the table use alter table to change the data type on the redacted table change the data types on all the fk fields recreate the fk you identified and dropped.
Never underestimate the power of human stupidity RAH
-
Then you have a serious design problem, what are the data type changes you want to affect? You could do this right by: Identify and drop all the FK referencing the table use alter table to change the data type on the redacted table change the data types on all the fk fields recreate the fk you identified and dropped.
Never underestimate the power of human stupidity RAH