如何在运行时在MS-Access中创建带有自动编号字段的表? [英] How to create table with Autonumber field in MS - Access at run time?

问题描述

我正在使用MS-Access和JSP.我想知道如何创建带有自动编号字段和主键的表.

I am working with MS-Access and JSP. I want to know that how can we create table with autonumber field and with primary key.

query ="Create Table Registration_A(Reg_No PRIMARY KEY AUTOINCREMENT， FName varchar(2));

query="Create Table Registration_A (Reg_No PRIMARY KEY AUTOINCREMENT, FName varchar(2))";

但是它给出了语法错误.正确的语法是什么?

But its giving syntax error. What's the correct syntax?

推荐答案

CREATE TABLE Registration_A (
Reg_No AUTOINCREMENT, 
FName VARCHAR(2), 
CONSTRAINT RegA_PK PRIMARY KEY(Reg_No))

这篇关于如何在运行时在MS-Access中创建带有自动编号字段的表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！