hi
i know how can i create a table with sql command
but i don't know how create a field with type integer ,autoNumber
(auto increase) and Primary key
Like id field in Access

may you change below code with add a field with above properties
Create Table " + TextBox1.Text + "(tex varchar ,topic
varchar(25)PRIMARY KEY)
thanks

Hello miladhatam,

What I think you're asking is how to create a table with a primary key that
is also an identity column. The following statement creates the MyCustomers
table with a CustID field/column as the primary key as an IDENTITY integer
which starts at 100 and increases at an increment of 1. It also has a
CompanyName column. Check out SQL Online Books:

CREATE TABLE MyCustomers (CustID INTEGER IDENTITY (100,1) PRIMARY KEY,
CompanyName NvarChar (50))

--
brians
http://www.limbertech.com


"(E-Mail Removed)" wrote:

> hi
> i know how can i create a table with sql command
> but i don't know how create a field with type integer ,autoNumber
> (auto increase) and Primary key
> Like id field in Access
>
> may you change below code with add a field with above properties
> Create Table " + TextBox1.Text + "(tex varchar ,topic
> varchar(25)PRIMARY KEY)
> thanks
>
>

brians äæÔÊå ÇÓÊ:
> Hello miladhatam,
>
> What I think you're asking is how to create a table with a primary key that
> is also an identity column. The following statement creates the MyCustomers
> table with a CustID field/column as the primary key as an IDENTITY integer
> which starts at 100 and increases at an increment of 1. It also has a
> CompanyName column. Check out SQL Online Books:
>
> CREATE TABLE MyCustomers (CustID INTEGER IDENTITY (100,1) PRIMARY KEY,
> CompanyName NvarChar (50))
>
> --
> brians
> http://www.limbertech.com
>
>
> "(E-Mail Removed)" wrote:
>
> > hi
> > i know how can i create a table with sql command
> > but i don't know how create a field with type integer ,autoNumber
> > (auto increase) and Primary key
> > Like id field in Access
> >
> > may you change below code with add a field with above properties
> > Create Table " + TextBox1.Text + "(tex varchar ,topic
> > varchar(25)PRIMARY KEY)
> > thanks
> >
> >
oh thanks
i find this code
id INT NOT NULL IDENTITY PRIMARY KEY ,tex varchar ,topic varchar(25))
but your code is better