Thanks a million guys !!

Tried the code by SQLkiwi and ColdCoffee (used t instead of t.column)

Worked perfectly

I am building a visual tool for managing a database.....

So a deleting a row...

Hmmm...this is strange !!

1. create table temp6 (id int unique primary key)

shows error: Both a PRIMARY KEY and UNIQUE constraint have been defined for column 'id', table 'temp6'. Only one...

Answering it myself...;-)

Tried on SQL Server 2008 management studio:

and it turns out answer for all Ques is Yes!!

...even though it is useless to set not null and/or unique when the...