answersLogoWhite

0

ALTER TABLE mytab MODIFY (mycol <modifications>)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you change the length of a column in SQL?

The column definitions of a table can be modified using the ALTER TABLE command.ALTER TABLE employeeMODIFY emp_name varchar2(100) not null;This command makes the emp_name as a not null column and a alpha numeric column of 100 characeter width


What is a column on a period table is called?

a column or family on the Periodic Table


What are Column Labels in the areas of a Pivot Table?

Each pivot table is different, so it depends on how you have it laid out and what data is in it. Pivot tables are very flexible, so you can switch around the data and column headings could become row headings and the data can change. Column headings will indicate what the data in a particular column in the pivot table is.


To add a column to the right of the last column of an existing Word table select table then?

to add a column to the right of the last column of an existing Word table select table then A. insert Columns to the Right B. insert Column C. insert Cells Column Right D. insert column 1


What is the difference between a column constraint and a table constraint?

column constraint is for a single column. table constraint is for an entire table.


What is a leftmost column?

It is the first column in a table on the left. In a spreadsheet it would be column A. In Access it would the column for the first field. In a table in Word, it would be the first column on the left.


In what column is beryllium in?

Beryllium is in column 2 of a wide form periodic table and column II(A) of a narrow form periodic table.


A vertical list of information in a table is called?

A vertical list of information in a table is called a "column"


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


What is the first column on the table?

For the table, turn on the First Column option


What are the components of relational database?

Table, index, trigger and column Table, index, trigger and column


How can you change Hansen into Nilsen in the LastName column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'