SQL statement for modifying table structure (oracle, t-SQL, MySQL)

Previously, I only talked about modifying the table structure in mysql. Today I will introduce some implementations of modifying the table structure in oracle, t-SQL, and MySQL. I hope this will be helpful to you.

 

Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions.

View column: desc table name;

Alter table t_book rename to bbb;

Add column: alter table name add column name varchar (30 );

Delete column: alter table Name drop column name;

Alter column name MySQL: alter table bbb change nnnnn hh int;

Modify the column name SQLServer: exec sp_rename 't_ student. name', 'nn ', 'column ';

Modify the column name Oracle: lter table bbb rename column nnnnn to hh int;

Alter table t_book modify name varchar (22 );

Sp_rename: the built-in Stored Procedure of SQL Server, which is used to modify the table definition.

Alter table CMS_Document add column Weighting INT (11 );

Well, if it's about modifying the table structure in SQL, you can test it one by one.