Add column in table of Oracle, Sql Server, Mysql & Postgresql

Add column in table of Oracle, Sql Server, Mysql & Postgresql

Sometime after creating the database schema and sturture we have to modified or add column in the table for future updates. So we need to modified the structure of the tables for future deployment. We can use this command to add column in databases.

Following are the example of add column in the table

Syntax:

ALTER TABLE

ADD datatype;

Example
Suppose need to add one more column in employee table
alter table employee add dateofjoin datetime;

SQL Server

ALTER TABLE table_name ALTER COLUMN column_name datatype;
ALTER TABLE dbo.table_name DROP COLUMN column_name;

Oracle

Alter table table_name modify column_name datatype;
alter table table_name drop column col_name1;

MySQL

ALTER TABLE MODIFY COLUMN datatype;
ALTER TABLE DROP ;

PostgreSQL

ALTER TABLE ADD COLUMN datatype ;
ALTER TABLE DROP COLUMN RESTRICT;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.