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

Ads
 

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

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

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,

Ads









Related Tutorials/Questions & Answers:
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
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
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
; 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
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
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
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
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
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
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 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
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
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
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
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 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
how to make JTable to add delete and update sql database table
how to make JTable to add delete and update sql database table  Hello all I want to know how to make JTable to act actively to add delete and update database table. i am struck ed here from long time please help me
How to display the data column on jsp
How to display the data column on jsp  My requirements: Display total error count of error description of each database server (column wise). like...(); column_count=dbSizeList.size(); //tempArray = new String
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
SQL add column default value
SQL add column default value       Add a Column default value is used in SQL, When create... with Example The Tutorial understand you a example from SQL add column default
Change Column Name in MySQL
: This is a data type of new column. First of all you will create MySQL database... In this example How to change column name in MySQL. First of all we have created MySQL database with many fields in table. We rename a column in MySQL using alter
while Append need a new line for column and row
while Append need a new line for column and row  HI While using append in javascript for retreiving the rows and its column header, its retreiving but after column header i need new line but it is not coming. Thanks in advance
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 multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet  i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

Ads