I've just been studying DBMS. There are a lot of programs for DB. (eg. Mysql, MariaDB etc..)
So I wonder in program, for example Postgresql, can I change data structure each table?
Most of programs are using B-tree, however I hope change data structure each table if I can.

CodePudding user response：

Are you asking if you can change the table structure like adding or removing columns, altering the data type of a column, if yes, then it is possible.

Refer here for postgresql syntax

Refer here for SQL Server/MS SQL syntax

Refer here for MySQL syntax