Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reset Table Column Back to 0

Status
Not open for further replies.
rocco

rocco

IS-IT--Management
Oct 30, 2001
106
0
0
CA
I have a couple of related tables that an identity value overflow occurred for a particular field x. I need to reset the column back to 0 but not sure what the command is...help is needed. I am running Adaptive Server Enterprise 12.5.4

The tables have no data as I have truncated the tables to get them prepare.

Thank you for looking at my post.
 
Sort by date Sort by votes
Drop table and recreate table to reset column value.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

AM_WG
  • Locked
  • Question
Need help with SQL query to update a Micros report
Replies
0
Views
72
AM_WG
AM_WG
bokswager
  • Locked
  • Question
modifying column on large table
Replies
0
Views
56
bokswager
bokswager
raphael75
  • Locked
  • Question
trying to call Sybase stored procedure with parameters from PHP
Replies
0
Views
55
raphael75
raphael75
baltman
  • Locked
  • Question
Precison too large error via Excel/ODBC solution needed
Replies
0
Views
54
baltman
baltman
SafwanSafwan
  • Locked
  • Question
sybase backup server error after restat
Replies
1
Views
55
PDreyer
PDreyer

Part and Inventory Search

Sponsor

Back
Top