Autonumber... - Microsoft SQL Server

Matrix

Sorry for my bad English but I'm Italian...

I have a question for you...
I delete all record of table but I don't set autonumber field to start with
value 1....
What do you do to set a values of autonumber colomns with Query Analizer or
Enterprise Manager...???

Jul 20 '05 #1

Subscribe Post Reply

6615

Shervin

I guess you are looking for a code to reset the identity seed for a table.
Here you go:

DBCC CHECKIDENT (TableName, RESEED, 1)
Shervin
"Matrix" <wd***********@tin.it> wrote in message
news:bk**********@grillo.cs.interbusiness.it...

Sorry for my bad English but I'm Italian...

I have a question for you...
I delete all record of table but I don't set autonumber field to start with value 1....
What do you do to set a values of autonumber colomns with Query Analizer or Enterprise Manager...???

Jul 20 '05 #2

Guinness Mann

In article <bk**********@grillo.cs.interbusiness.it>,
wd***********@tin.it says...

What do you do to set a values of autonumber colomns with Query Analizer or
Enterprise Manager...???

I worried about that for a long time, too. It just seemed unnatural to
have a bunch of missing numbers. But after continually resetting them
(there are a couple of ways to do it -- I see someone already is helping
with that) I finally realized that there is no reason to do so.

Think what the numbers will look like after a few weeks of production.
-- Rick

Jul 20 '05 #3

Jason

Since you want to delete all the rows in the table you can use

TRUNCATE TABLE table_name

That will delete all rows AND reset the seed in one command.

- Jason

"Matrix" <wd***********@tin.it> wrote in message
news:bk**********@grillo.cs.interbusiness.it...
Sorry for my bad English but I'm Italian...

I have a question for you...
I delete all record of table but I don't set autonumber field to start

with
value 1....
What do you do to set a values of autonumber colomns with Query Analizer

or
Enterprise Manager...???

Jul 20 '05 #4

Trevor Best

On 25 Sep 2003 10:57:39 -0700 in comp.databases.ms-sqlserver,
Ja*******@hotmail.com (Jason) wrote:

Since you want to delete all the rows in the table you can use

TRUNCATE TABLE table_name

That will delete all rows AND reset the seed in one command.

Doesn't seem to work if you have foreign key constraints.

--
A)bort, R)etry, I)nfluence with large hammer.

Jul 20 '05 #5

Similar topics

How do I add an autonumber

by: Ilan Sebba | last post by:

I have a 'supertype' table with only one field: autonumber. Call this table the 'parent' table. There are two subtypes, 'androids' and 'martians'. Martian have only one thing in common: they give...

Microsoft Access / VBA

Table w/ Autonumber AND Cascade update

by: Lee C. | last post by:

I'm finding this to be extremely difficult to set up. I understand that Access won't manage the primary key and the cascade updates for a table. Fine. I tried changing the PK type to number and...

Microsoft Access / VBA

Restart Autonumber

by: Traci | last post by:

If I have a table with an autonumber primary key and 100 records and I delete the last 50 records, the next record added would have a primary key of 101. Is there any way to have the primary key...

Microsoft Access / VBA

Will "Random AutoNumber" reuse deleted values?

by: yf | last post by:

A KB article "http://support.microsoft.com/default.aspx?scid=kb;en-us;209599" tells that the maximum number of records that a table may hold if the PRIMARY key data type is set to AUTONUMBER is...

Microsoft Access / VBA

AutoNumber Regeneration

by: jimfortune | last post by:

Sometimes I use Autonumber fields for ID fields. Furthermore, sometimes I use those same fields in orderdetail type tables. So it's important in that case that once an autonumber key value is...

Microsoft Access / VBA

SQL Insert, Autonumber, and End of Table ???

by: petebeatty | last post by:

I have created a SQL string the properly inserts a record in the table. However, the insert does not occur at the end of the table. Instead it inserts a record after the last record that I viewed....

Microsoft Access / VBA

VB6 app may need to generate its own ACCESS AUTONUMBER VALUES???

by: Alan Mailer | last post by:

A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...

Microsoft Access / VBA

Detecting when AutoNumber field = NULL

by: gtwannabe | last post by:

I'm having a problem with a form that uses AutoNumber as the primary key. I have an Abort button to delete the current record and close the form. If AutoNumber is assigned, the code executes a...

Microsoft Access / VBA

Duplicate numbers in "Autonumber" field -- help!

by: Tom_F | last post by:

To comp.databases.ms-access -- I just discovered, to my more than mild dismay, that some tables in my Microsoft Access 2003 database have duplicate numbers in the "AutoNumber" field. (Field...

Microsoft Access / VBA

Inserting records into MS Access where there is an autonumber for a primary key

by: ashes | last post by:

Hi, I am creating an ecommerce website using Microsoft Visual Studio, VB.Net and MS Access 2003. I am new to VB.Net When someone wants to register on the website, they fill out a form and the...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp