I need to change the primary key of a table in a script in Sybase 11.
Before I change it I need to make sure that it hasn't already been changed. How do I check to see if the primary key has already been changed
If Not Exists (Select 0 IF 'TableName' has primary key of (col1,col2)) Then
How would the psuedo Select statement really look?