Hi all
I m Trying to alter Primary key as Case sensitive in Existing table i used below query to alter
ALTER TABLE mytable
ALTER COLUMN mycolumn VARCHAR(10)
COLLATE SQL_Latin1_General_CP1_CS_AS
But my Problem is im refereing myTable as Foreign Key in Couple of Tables how can i I alter without affecting Dependncies Pls help