Answers for "create table primary key"

SQL

create table with primary key

CREATE TABLE student_id
(
Column1 datatype,
Column2 datatype,
Column3 datatype,

PRIMARY KEY (student_id);

Posted by: Guest on August-20-2021

add primary key to table

ALTER TABLE Persons

ADD PRIMARY KEY (ID);

Posted by: Guest on June-07-2021

Source

sql primary key

-- NOTE: this is for SQL-Oracle specifically

-- example:
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name = 'CUSTOMERS' 
AND cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner;

-- syntax:
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name = '<table-name>' -- Replace <table-name> with your table-name
AND cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner;

Posted by: Guest on April-28-2020

Code answers related to "create table primary key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "create table primary key"

Code answers related to "create table primary key"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us