Search
 
SCRIPT & CODE EXAMPLE
 

SQL

primary key

CREATE TABLE Persons (
    Rollno int NOT NULL,
    FirstName varchar(255),
    LastName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);
Comment

what is primary key

PRIMARY KEY  -- unique identifier for the entire row of record in a table 
             -- can not be null and must be unique 
Comment

primary key

Primary Key :
It is unique column in every table in a database
It can ONLY accept;
    - nonduplicate values
    - cannot be NULL
Comment

PREVIOUS NEXT
Code Example
Sql :: foreign key sql 
Sql :: drop table oracle 
Sql :: hour differeence in mysql 
Sql :: how to install mysql workbench in ubuntu 20.04 
Sql :: end mysql command 
Sql :: sql recherche nom prenom 
Sql :: wp_query raw sql 
Sql :: what is table in sql 
Sql :: sql query for displaying age from oldest to youngest 
Sql :: find the names of sailors who have reserved at least one boat 
Sql :: where name ends in SQL 
Sql :: sql ssrs 
Sql :: postgres enumerated type 
Sql :: min and max salary and name in sql 
Sql :: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: sql composite primary key 
Sql :: create procedure sql 
Sql :: sql double quotes in string 
Sql :: mysql split explode 
Sql :: postgres isnull 
Sql :: sql limit 
Sql :: sql offfset 
Sql :: sql examples from framework 
Sql :: delete from table and truncate table 
Sql :: 5000/208 
Sql :: sort by 
Sql :: sql convert to linq online 
Sql :: how to see table associated with a schema in sql 
Sql :: no customers ordered 
Sql :: how to get node value of xml in sql server 
ADD CONTENT
Topic
Content
Source link
Name
1+3 =