Solved

delete contraint will bring me problems?

Posted on 2011-03-02
1
264 Views
Last Modified: 2012-05-11
To make the example above, I had to delete the primary key contraint
ALTER TABLE [dbo].[tabla_demo] DROP CONSTRAINT [PK__tabla_de__3213E83F0519C6AF]

 I can always do that?
Where should I care?
lose the integrity of the data?

0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 16

Accepted Solution

by:
vdr1620 earned 250 total points
ID: 35020550
There are various reasons why a Primary Constraint is created as listed below.. If you think that none of these are really important than ..you do not need to create a constraint ..instead of dropping it multiple times

http://msdn.microsoft.com/en-us/library/ms181043.aspx

0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question