How to find primary key of a table in databricks

Structured Query Language or SQL, is composed of commands that enable users to create database and table structures, perform various types of data manipulation and data administration and query the database to extract useful information.

We will start with creating the database “geeksforgeeks” and then we will proceed with creating a table “interns” in that database. After this we will execute our query on the table.

Creating Database :

CREATE DATABASE geeksforgeeks;

To use above created database :

USE geeksforgeeks;

Create Table :

CREATE TABLE interns( id SERIAL PRIMARY KEY, name VARCHAR(30), gender VARCHAR(1), mobile BIGINT, email VARCHAR(35), city VARCHAR(25));

To see description of above created table :

DESC interns;

Insert data into the table :

INSERT INTO interns(name, gender, mobile, email, city) VALUES ('Richa', 'F', '7999022923', 'richa@gmail.com', 'Delhi'); INSERT INTO interns(name, gender, mobile, email, city) VALUES ('Shivam', 'M', '9999028833', 'shivam@gmail.co

sql identity primary key

how to determine primary key in sql