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
Define the one-to-one relationship while designing tables.
What are diverse clauses that form a part of sql?
What is the difference between sdf and mdf?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What are 3 ways to get a count of the number of records in a table?
What is amo? : sql server analysis services, ssas
How to loop through returning rows?
What is the use of sql profiler in sql server 2012?
How use inner join in sql server?
Explain Capacity planning to create a database? and how to monitor it?
what is a schema in sql server 2005? : Sql server database administration
If the job running very slow what is the action you do
What is a join in sql? What are the types of joins?
What is a result set object returned by odbc_exec()?
how to take backup bcp out for a column in table in sql server?
