|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
altering unique index to primary keyIs there a way to alter a unique clustered index in a table to a primary key
with some magic alter statement? What I want to avoid (if possible) is to run drop/create statement, just to make already unique clustered index to a Primary key. I appreciate your reply. I have sql server 2000 SP4. Hi James
I don't think this possible with command. Why do you want to change this? John Show quoteHide quote "James" wrote: > Is there a way to alter a unique clustered index in a table to a primary key > with some magic alter statement? > > What I want to avoid (if possible) is to run drop/create statement, just to > make already unique clustered index to a Primary key. > I appreciate your reply. I have sql server 2000 SP4. > > > I wanted to replicate these tables via Transactional replication and it
requires a Primary key. Since the tables are big, I wanted to save some time if that was possible. Show quoteHide quote "John Bell" <jbellnewspo***@hotmail.com> wrote in message news:F688407C-5A69-4B1E-B0E7-76100DE23F5E@microsoft.com... > Hi James > > I don't think this possible with command. Why do you want to change this? > > John > > "James" wrote: > >> Is there a way to alter a unique clustered index in a table to a primary >> key >> with some magic alter statement? >> >> What I want to avoid (if possible) is to run drop/create statement, just >> to >> make already unique clustered index to a Primary key. >> I appreciate your reply. I have sql server 2000 SP4. >> >> >> Hi James,
> I wanted to replicate these tables via Transactional replication and it Are you saying you created the tables without a primary key? Is that > requires a Primary key. > something you regularly do? Ruud de Koter.  
Thread options
Other interesting topics
sms shows new job dialog when view properties
Two related tables transpose table 2. installing sql server 2005 express with advanced services sp2 SQL Server Read/Write Request Size from the Disk IO Subsystem Temp table solve the performance issue? Stored procedure sp_sqlagent_get_perf_counters uses too much cpu t sys.dm_db_index_usage_stats Memory issue Upsert Insert/Update using Except and Intercept Role to create views only |
|||||||||||||||||||||||
