Answer Posted / sql2000
Its Possible, run the below code and have a look...
begin transaction
create table test (col1 int, col2 int)
insert into test values (1, 1)
insert into test values (1, 2)
insert into test values (1, 3)
insert into test values (2, 1)
delete from test where col1 = 2
alter table test
alter column col2 int not null
alter table test
add
constraint [pk_col2] primary key nonclustered(col2) on
[primary]
rollback transaction
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the beast way to write CTE in SQL Server ?
How can I tell if sql server is 32 or 64 bit?
Can a table have 2 primary keys?
Which joins are sql server default?
what types of replication are supported in sql server? : Sql server database administration
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain difference between control flow and data flow?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How to enter comments in transact-sql statements?
Explain concepts of analysis services?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What are the advantages dts has over bcp?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is row_number () and partition by in sql server?
What is join query?