answersLogoWhite

0

Alter table command is not a part of the ANSI standard, but is widely available. Its form is fairly consistent, although its capabilities vary considerably.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is difference between alter and modify on oracle?

MODIFY is a clause used within an ALTER statement, such as ALTER TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY isn't a command by itself. For example, you might change the length of a text column in a table with the following: ALTER TABLE employee MODIFY (email_address VARCHAR(132));


How can you change column in the table?

ALTER TABLE mytab MODIFY (mycol <modifications>)


What is the homonym for alter?

The homonym for alter is altar. "Alter" means to change or modify, while "altar" refers to a table or platform used in religious ceremonies.


Which one is a system privilege a select b delete c execute d alter table e create table?

Create table


What are some of the functions for the alter table command in Oracle?

Some of the functions for the alter table command in Oracle include renaming columns or rows, adding columns or rows and marking items as being read only.


What is the cloth covering the table on the alter called?

An altar cloth.The altar cloth


What is the other spelling for alter?

# verb, to alter, means to change something. # noun, an altar, is a flat-topped block or table that is used in religious services.


How can you add column after table creates in sql server 2005?

plz reply me argent You can do it through Management Studio by right clicking on the table that you want to add the column to and select design. Or you can run a ALTER TABLE statement ALTER TABLE <TableName> Add <NewColumnName> <DataType> <DefaultValue> <NULL or NOT NULL> Keep in mind you do not need to specify a Default Value. Also note that it will drop to the bottom of the column list based on ordinal position. ALTER TABLE ErrorLog Add IsDeleted BIT DEFAULT (0) NOT NULL


Oracle Alter a column's varchar length I want to change a varchar30 to a varchar20. can please help me get the syntax for it?

ALTER TABLE table_name MODIFY (column_name VARCHAR2(20));


Can you add new columns to a database after creating the structure?

Columns are added to a table, not a database (which is a collection of tables). Adding a column to a table is achieved by using the Alter Table SQL command.


How you can delete a column from the table?

Can you be more specific? What kind of table do you mean, and what program are you using? A SQL statement like this will do it: alter table tblName drop column colName tblName is the name of the table colName is the name of the column


Query used to add fields to existing tables?

The query can be called an Append query. New columns can be added to existing tables by using the ALTER TABLE command in SQL. ex: ALTER TABLE tbl_employee ADD emp_address VARCHAR(100); The above command adds a column emp_address to an existing table tbl_employee