Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL How to Delete a column and Add a new column to database
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
How to Delete a column and Add a new column to database
1 Answer(s)      4 years and a month ago
Posted in : SQL


How to Delete a column and Add a new column to database


Advertisement
View Answers

November 20, 2010 at 11:47 AM


Hi,

The following query is executed for add and delete a column in a table-

for drop a column-

alter table [table name] drop column [column name];

for add a column in a table-

alter table [table name] add column [new column name] varchar (20);

Thanks,



Related Tutorials/Questions & Answers:
How to Delete a column and Add a new column to database
How to Delete a column and Add a new column to database   How to Delete a column and Add a new column to database   Hi, The following query is executed for add and delete a column in a table- for drop a column
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new... TABLE table_name ADD column_name column-definition Suppose, we have a table... new fields dateOfJoining and address. Then using the given query, we can add
Advertisements
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new... TABLE table_name ADD column_name column-definition Suppose, we have a table... new fields dateOfJoining and address. Then using the given query, we can add
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new... TABLE table_name ADD column_name column-definition Suppose, we have a table... new fields dateOfJoining and address. Then using the given query, we can add
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new... TABLE table_name ADD column_name column-definition Suppose, we have a table... new fields dateOfJoining and address. Then using the given query, we can add
Delete a Column from a Database Table
to delete a column from a database table. We are not going to create a new table... Delete a Column from a Database Table   ...;  col_name; This code is used to delete the column form a database
How to add a column in a table
have to add a new column to our database by using the java program... How to add a column in a table   ... the query in the prepareStatement() for adding new column in the database
SQL Add Column
; SQL Add Column is used to add a new column in the existing table... add a new column to the table. The Syntax for the Add Column is given... Query define a Alter Table that modifies and add a new column 'Stu_Class
Delete a column
Delete a column       In this section, you will learn how to delete a column from database table using jpa. You need the following artifacts: Database table: student Model
SQL Add Column Int
; SQL Add Column Int is used to add new column, whose field data type... to alter the table table_name.The Add keyword is used to add a new column... you a modified Stu_Table using Alter keywords, which add a new column
Mysql Alter Add Column
and add a new column to it. Understand with Example...' and add a new column 'city' to the existing table 'employees... Mysql Alter Add Column     
sql add comment to column
sql add comment to column  Sql query to add comments to column
Adding a New Column Name in Database Table
Adding a New Column Name in Database Table  ... are going to learn about adding a new column in database table. Sometimes it happens..., it takes table name, column name and it's data type and at last add a new column
how to Change column name and Make a unique column.
how to Change column name and Make a unique column.   how to Change... table [table name] change [old column name] [new column name] varchar (50); for make a column unique- alter table [table name] add unique ([column name
MySQL Add Column
the table 'employee' and add a new column 'address' to the existing table 'employee... MySQL Add Column       MySQL Add Column is used to add the column to the existing table
MySQL Add Column
Table employee is used to modify the table 'employee' and add a new column... MySQL Add Column       MySQL Add Column is used to add the column to the existing table. The Alter table
SQL Add Column
; SQL Add Column is used to add a new column in the existing table. Understand... add a new column to the table. The Syntax for the Add Column is given... a Alter Table that modifies and add a new column 'Stu_Class' to the table 'Stu
Mysql Add Column Number
Mysql Add Column Number       Mysql Add Column Number is used to add the column to the existing table... 5 Santosh SQL Add Column Syntax The Alter is used to modify
Appending a Column in JTable
;  In this section, you will see how to add a new column... of program: In this program, we will see how to add (append) a new column in JTable..._name): This is the method that is used to add a new column to the model. It takes
How to add a column with checkboxes for each record in my table in JSP
How to add a column with checkboxes for each record in my table in JSP   Hi, Could you please explain it to me how I can add a column with check boxes for each record in my table in JSP? Also, I want to figure out a way
SQL Add Column Int
; SQL Add Column Int is used to add new column, whose field data type... is used to add a new column in a table. ALTER TABLE table_name ADD... a new column Stu_Class using add keyword, whose data is integer type
mysql alter table add column
mysql alter table add column  Hi, What is the syntax of mysql alter table add column? Thanks   Hi, Here is mysql alter table add column example: ALTER TABLE employee ADD address VARCHAR(50); Read more at MySQL Add
adding some value to new column
adding some value to new column   how to update a column having some value into new column that also have some value i need to add this two value in java using result set we can get all the column data but how to add these value
SQL Add Column Position
SQL Add Column Position       SQL Add Column Position is used to add the column at the specific... The Tutorial illustrates an example from SQL Add Column Position to the existing
How to insert and update all column values of database from jtable.
How to insert and update all column values of database from jtable.  ... ,update,delete database values from jtable only so i added three buttons add... . when we add new records into the database then last last record
MySQL Add Column
the table 'employee' and add a new column 'address' to the existing table 'employee... MySQL Add Column       MySQL Add Column tutorial explains you to add the column to the existing
How to insert and update all column values of database from jtable.
How to insert and update all column values of database from jtable.  ... ,update,delete database values from jtable only so i added three buttons add,update... . when we add new records into the database then last last record of particular
How to insert and update all column values of database from jtable.
How to insert and update all column values of database from jtable.  ... ,update,delete database values from jtable only so i added three buttons add,update... . when we add new records into the database then last last record of particular
how to add components (like button , checkbox etc) in a table column in core java
how to add components (like button , checkbox etc) in a table column in core java  plz tell me how to add components(like button, checkbox, radiobutton etc)in a table column in core java
sum database column
3 Soap 4 how will i query the database to sum the Items...sum database column  please i have two columns-col1 and col2, col1 contain item and col2 contain the quantity of the item col1 col2 Key
SQL Add Column Int
SQL Add Column Int       SQL Add Column Int modifies the definition of table and add a new column... to modify the table definition and add a new column 'class' to the existing
Advertisements
 

 

 

DMCA.com