alter add column in the table

ALTER 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 ;

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.