How to add and drop primary key in SQL Server
If you want to add primary key after you create the table in the sql server, then
1. go to Microsoft SQL Server Management Studio
2. Right click on the database and select new query
3. ALTER TABLE tbl_name ADD PRIMARY KEY(pr_key_column);
tbl_name – name of the table you want to assign primary key
pr_key_column – column/field name which you want it to be primary key
If the pr_key_column is allowed null values, then you can’t assign it as primary key. So if that is the case use this query first:
ALTER TABLE tbl_name ALTER COLUMN pr_key_column datatype not null;
To revoke primary key:
ALTER TABLE tbl_name DROP CONSTRAINT(pr_key_column);
See how you would solve these known algorithm problems
Changing decimal number to its binary equivalentFind K Complementary numbers from array Java implementation
Check if there are three numbers a, b, c giving a total T from array A
find longest word in the sentence
Implement Queue Using two Stacks – JavaScript algorithm
Flatten nested javascript array
testing k complementary pairs algorithm with junit
Finding missing numbers from billion sequential number list file
Check if two strings are anagrams or not
Find the first occurence of number in the sorted array