Javin Paul
Posts: 1090
Nickname: javinpaul
Registered: Jan, 2012
|
Javin Paul is Java Programmer working on Finance domain.
|
|
|
|
How to use ALTER COMMAND in SQL - database tutorial
|
Posted: Jan 2, 2013 7:03 AM
|
|
|
This post originated from an RSS feed registered with Java Buzz
by Javin Paul.
|
Original Post: How to use ALTER COMMAND in SQL - database tutorial
Feed Title: Java67
Feed URL: http://www.java67.com/feeds/posts/default?alt=rss
Feed Description: Java and technology tutorials, tips, questions for all programmers.
|
Latest Java Buzz Posts
Latest Java Buzz Posts by Javin Paul
Latest Posts From Java67
|
|
In this SQL tutorial we will see
how to use ALTER command command in table on database. ALTER command is mainly
used to add, modify and drop columns, indexes and constraints on table in
relational database e.g. MySQL,
Oracle,
Sybase
and SQL Server. Though ALTER is not part
of classical CRUD operation but it’s one of the important DDL
command. One of the most frequent use of ALTER command in SQL is adding and
removing indexes to improve performance of SQL
SELECT queries. In this SQL and database tutorial we will see different
ways of using ALTER command. By using ALTER command we can add, edit or modify
table, views and databases. We can add new column on the table, we can change
value of column or we can rename column also.
Read more »
Read: How to use ALTER COMMAND in SQL - database tutorial
|
|
Previous Topic
