Solved

delete contraint will bring me problems?

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Trying to identify overlapping date ranges 5 22
SQL query with cast 38 43
Please help with the below query - SQL Server 11 20
sql how to count case when 4 18
In this article I will describe the Backup & Restore 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.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 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