Answers for "SQL table properties"

SQL
3

sql table

CREATE TABLE utilisateur
(
    id INT PRIMARY KEY NOT NULL,
    nom VARCHAR(100),
    prenom VARCHAR(100),
    email VARCHAR(255),
    date_naissance DATE,
    pays VARCHAR(255),
    ville VARCHAR(255),
    code_postal VARCHAR(5),
    nombre_achat INT
)
Posted by: Guest on May-20-2020
0

table structure in sql

select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='<Table Name>'
Posted by: Guest on April-22-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language