Solved

delete contraint will bring me problems?

Posted on 2011-03-02
1
245 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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now