Java67 - Java Program Example Tutorial Blog |
| How to use ALTER COMMAND in SQL - database tutorial Posted: 02 Jan 2013 06:18 AM PST 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. |
| You are subscribed to email updates from Java67 - Java Program Example Tutorial Blog To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
Post a Comment