Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Manoj Kumar » How Truncate statement ?
Add to briefcase
34 posts, Page 1 of 4
1234»»»

How Truncate statement ? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Manoj KN
Posted Wednesday, October 20, 2010 9:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 5:36 AM
Points: 51, Visits: 71
Comments posted to this topic are about the item How Truncate statement ?
Post #1008144
lukus_g
Posted Wednesday, October 20, 2010 10:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 4:22 PM
Points: 187, Visits: 76
yikes... i chose error while truncating due to the fact the table wasn't named correctly in the truncate statement....
Post #1008160
Kingston Dhasian
Posted Wednesday, October 20, 2010 10:58 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:48 AM
Points: 2,202, Visits: 4,157
Good Question. One more point can be added to the answer.
You can truncate a table that has a foreign key that references itself

See the link to the BOL below
http://msdn.microsoft.com/en-us/library/ms177570.aspx

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1008170
sharath.chalamgari
Posted Wednesday, October 20, 2010 11:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679
Nice Question : )

Yes we can not use truncate on a table which is referenced by a FOREIGN KEY constraint

The below statement is true if it is not referenced with any FOREIGN KEY:

If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used.
Post #1008175
sharath.chalamgari
Posted Wednesday, October 20, 2010 11:27 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679
Nice Question : )

Yes we can not use truncate on a table which is referenced by a FOREIGN KEY constraint

The below statement is true if it is not referenced with any FOREIGN KEY:

If the table contains an identity column, the counter for that column is reset to the seed value defined for the column. If no seed was defined, the default value 1 is used.
Post #1008176
Hardy21
Posted Wednesday, October 20, 2010 11:51 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158
Nice question.
Delete is working for CustomerMaster table but truncate throws an error. I would like to know why it is not working? Any specific reason?

Thanks
Post #1008184
jshailendra
Posted Thursday, October 21, 2010 12:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 21, 2012 5:24 AM
Points: 366, Visits: 436
me too, although i know the logic behind truncate
Post #1008198
pravin wagh
Posted Thursday, October 21, 2010 12:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, November 26, 2012 4:40 AM
Points: 129, Visits: 123
it truncates CustomerDocuments table
but not CustomerMaster Error Message fk ref. fired while truncating CustomerMaster.
Post #1008199
William Rooks
Posted Thursday, October 21, 2010 12:38 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, August 20, 2012 2:41 AM
Points: 17, Visits: 20
The error you will get is: CostomerMast does not Exist!!!

The table is called CostomerMastER
Post #1008200
Hardy21
Posted Thursday, October 21, 2010 12:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:42 PM
Points: 877, Visits: 1,158
w.rooks (10/21/2010)
The error you will get is: CostomerMast does not Exist!!!

The table is called CostomerMastER


This was typo mistake.
If you change it to CustomerMaster still SQL throws an error:
Cannot truncate table 'CustomerMaster' because it is being referenced by a FOREIGN KEY constraint.

Thanks
Post #1008201
« Prev Topic | Next Topic »

Add to briefcase
34 posts, Page 1 of 4
1234»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.