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



Home Answers Viewqa SQL how to Change column name and Make a unique column.
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
how to Change column name and Make a unique column.
1 Answer(s)      4 years ago
Posted in : SQL


how to Change column name and Make a unique column.


Advertisement
View Answers

November 20, 2010 at 11:51 AM


Hi,

Following queries are used to rename a column and to make a column unique.

for rename a column-

alter 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]);

Thanks,



Related Tutorials/Questions & Answers:
how to Change column name and Make a unique column.
how to Change column name and Make a unique column.   how to Change column name and Make a unique column.   Hi, Following queries...); for make a column unique- alter table [table name] add unique ([column name
Change Column Name in MySQL
.style1 { color: #0000FF; } Change Column Name in MySQL In this example How to change column name in MySQL. First of all we have created MySQL... Table name and change. The current column is named old_col but if you want
Advertisements
Make Unique Column in Database Table
is used to make unique of any column . It takes table name and column name. Here... Make Unique Column in Database Table   ... that it will run,  Now give the table name and column name to which you want to make
Changing column name
the name of the column. As this is not the work of the programmer to change the name of the field, but as a programmer we should be aware how we can change... Changing column name      
Changing the Name of Column in a JTable
the name of column, you must have to change the column header. For changing the name of column, you will need the index of column. Here, you will learn how to change.... Description of program: This program helps you to change the name of column
Change Column Name of a Table
Change Column Name of a Table   ... to change the name of the particular column. So, please don't panic. Here...: This is a name of the table in which we have to change the column name.   old_col
SQL Alter Column Name
; Alter Column Name in SQL is used to change or modify the name of column...:  Alter table table_name change old_column_name new_column..._Table'. The change keyword change the column name of  Stu_Id to Id
Altering a Column name in a table
Altering a Column name in a table  how to alter column name in MSSQL server 2005 the codesample given using "change" keyword alter table tablename change oldcolumnname to newcolumnname is not working
Excel Column change
Excel Column change  How to change sequence of columns in Excel sheet through Java
SQL Alter Column Name
SQL Alter Column Name       Alter Column Name in SQL is used to change or modify the name... a simple example on SQL Alter Column Name. In this Example, create
How to copy existing column along with data and column name into another existing table
How to copy existing column along with data and column name into another... and column name also into another existing table... For ex; TableA : Address email... hyd xyz 678 how to do this.... i know that firstly the column
Remove Unique Column in Database Table
that it will take a table name and column name from which we want to remove the unique key... Remove unique column example! Enter table name: Student Enter column name which has unique values: Stu_id Query OK, 5 rows
how to change a column data in a every row in a text file in java
how to change a column data in a every row in a text file in java   ...$ ........ so many lines are there like this i need to change 4th column in every row ie. account number to some text in a text file in java could
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...- 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
runtime error:Invalid column name
; } } Console Output: Getting Results! java.sql.SQLException: Invalid column name...runtime error:Invalid column name  Hello, Can anyone please help me...(Result.java:9) SQL> desc EMS_Poll; Name
SQL get Column Name
SQL get Column Name       SQL get Column Name is used to return the Fieldnames of the table... get Column Name'. To understand and elaborate example we create a table 'stu
Display the column name using DBCP
;Columns Name: ");         ...;    System.out.println(col_name);     
how to get values for same column name from two different tables in SQL
how to get values for same column name from two different tables in SQL  how to get values for same column name from two different tables in SQL???? column name is emp_id loacated in these two tables company,employee
Mysql Alter Column
below is used to modify the table 'employee1' and change the name of column from...; Mysql Alter Column is used to modify table and  change the existing column field name. Understand with Example The Tutorial illustrate
Shorting Table View By Column Name
Shorting Table View By Column Name This tutorial explains how to shorting table view by column name from the database in JSP and Servlet. This example... shorting  table view by column name. The code of "userdetails.jsp
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new column in table before two column in sql.   Syntax of Alter table: ALTER TABLE table_name ADD column_name column-definition Suppose, we have a table
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new column in table before two column in sql.   Syntax of Alter table: ALTER TABLE table_name ADD column_name column-definition Suppose, we have a table
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new column in table before two column in sql.   Syntax of Alter table: ALTER TABLE table_name ADD column_name column-definition Suppose, we have a table
how to add new column before two column in sql.
how to add new column before two column in sql.  how to add new column in table before two column in sql.   Syntax of Alter table: ALTER TABLE table_name ADD column_name column-definition Suppose, we have a table
How to add a column in a table
How to add a column in a table   ... should know how you can modify the structure of the table. The problem is that we have to add a new column to our database by using the java program
Mysql Alter Unique Key
;  Mysql Alter Unique is used to change the table structure and add unique key on specified column of a table.It allows one NULL value to be inserted in the column. Table can contains more than one unique keys. Understand
Mysql Alter Column Size
Mysql Alter Column Size       Mysql Alter Column Size is used to change the data size... 'employees' and change the size of column datatype. mysql> alter
Name unique
. In other words, value for the name should be unique...Name unique  I want to check whether the value which I give for the name textfield already exists in the database. In case if it exists , it should
column matrix
column matrix  columan wise total matrix
column matrix
column matrix  columan wise total matrix
Blob column
Blob column  Hi all... How to store an excel file in Blob column? I m using oracle 11 g database
Advertisements
 

 

 

DMCA.com