How do I specify a Primary Key in Sqlite

Question

How to define your specified attribute like StudentId in student table as Primary key in sqlite

Answer 1

CREATE TABLE Student(
  id INTEGER PRIMARY KEY,
  first_name TEXT, 
  last_name TEXT
);

From the Sqlite spec:

One exception to the typelessness of SQLite is a column whose type is INTEGER PRIMARY KEY. (And you must use "INTEGER" not "INT". A column of type INT PRIMARY KEY is typeless just like any other.) INTEGER PRIMARY KEY columns must contain a 32-bit signed integer. Any attempt to insert non-integer data will result in an error.

http://www.sqlite.org/datatypes.html

You can also place a primary key on the arbitrary blobish data eg:

CREATE TABLE Student(id PRIMARY KEY, name)

Its a bit risky cause

INSERT INTO Student(1, "hello") 
INSERT INTO Student("1", "hello")

will result in two rows.

If you need a unique constraint on other stuff you can try using the Create Index command

Answer 2

CREATE TABLE Students (
  StudentId INTEGER PRIMARY KEY,
  Name VARCHAR(80)
)

is one simple way.