Several Programming Questions

I've looked everywhere to find a place that would give me a SQL statement that creates (or modifies) an integer field with auto increment (Autonumber) in my MS ACCESS database.

Below are some of the statements I've tried unsuccessfully!

"CREATE TABLE table_name
(int_field INT AUTOINCREMENT)"

"CREATE TABLE table_name
(int_field INT AUTONUMBER)"

"CREATE TABLE table_name
(int_field INT COUNTER(1,1))"

"CREATE TABLE table_name
(int_field INT UNIQUE IDENTIFIER)"

Can someone please help me!

Thanks in advance.

You can find the syntax for MySQL, SQL Server, Access, and Oracle over here.

What are the authentication modes in SQL Server? How can it be changed?

What are the properties and different Types of Sub-Queries?

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

What is difference between DELETE & TRUNCATE commands?

What are the different index configurations a table can have?

Assuming you're refering to SQL, "TRUNCATE" will delete all of the rows in a table and depending on the SQL engine and engine version, reset any counters such as auto_increment. "DELETE" gets rid of the entire table completely instead of just emptying it.

What type of server should we assume?

The two are very similar, however, the HAVING clause can be used in conjunction with aggregate clauses (like GROUP BY), which allows you a slightly different approach. Have a look here for a more detailed explanation:

http://www.itjungle.com/fhg/fhg050907-story01.html

Are we doing your homework or what? This is ridiculous - this is like the 5th school-esque question I've answered for you this morning. LMGTFY

How do I adopt or take over a module already on CPAN?

What's the difference between dynamic and lexical (static) scoping? Between local() and my()?

How can I catch accesses to undefined variables, functions, or methods?

How do I clear a package?