Mastering SQL: Creating Databases, Crafting Tables, and Perfecting Table Modification

#postgresql #opensource #postgres
DDL: Data Definition Language
DDL to create database, table, user, schema and more

create database Smartcity;

create table landparcel(LandparcelID serial PRIMARY KEY,
AssetArea real,
LandUse varchar);

create table owner(
gid serial PRIMARY KEY,
Title varchar,
FirstName varchar,
LastName varchar);

alter table owner
add column city Varchar;

alter table owner
RENAME COLUMN city TO region;

ALTER TABLE owner
DROP COLUMN city;

drop table owner;

[amirrezashojaeinouri]

Many thanks for providing these helpful videos🙏🏽

[zahranik]

Thanks a lot for this practical video👌🏻👏🏻