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.
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.
Previous Topic
