/SQL/Id primary key auto generated

Id primary key auto generated

Id primary key auto generated

CREATE TABLE Persons (
    Personid int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

4

Similar codes

2 votes255 views2 answers
How to rename column name in sql server using query
SQL
0 vote252 views2 answers
Mysql add days to date
SQL
0 vote255 views1 answer
T sql less than date
SQL
0 vote252 views1 answer
Sql server order by nulls last
SQL
0 vote289 views1 answer
How to fetch data from database in sql
SQL
0 vote265 views1 answer
How to select an index in oracle sql
SQL
0 vote262 views1 answer
Test the postgresql db connection
SQL
0 vote249 views1 answer
Get last updated row sql server
SQL
2 votes275 views1 answer
Q operator in oracle
SQL
4 votes251 views1 answer
Sql query to make a existing column auto increment
SQL

Share