AD

Modify the table column names

You can use sp_rename

If sp_rename 'tableName.oldName' newName 'column'

tableName the table name, oldName the original column name, newName the new listing
标签: column name, table column, column names
分类: Database
时间: 2010-10-25

相关文章

  1. Oracle modify the table column names and order of the solution (sql modify column name)

    Oracle 10g modify the table column names and order of the solution - The following describes the method by mod ...
  2. Oracle to modify the table column names and order of the solution (sql modify column name)

    Oracle 10g in order to modify the table column names with a solution - The following describes the method by m ...
  3. Modify, add, delete, table names and table column names

    -- Test table create table TEST ( ID NUMBER not null, NAME VARCHAR2(20) ) ALTERTABLESCOTT.TESTRENAMETOTEST1-- ...
  4. Modify the table field names

    oracle sql modify table field names: -- Changing field names alter table tb_user_test rename column neme to cn ...
  5. Obtain the data table column names

    ResultSet rs = stmt.executeQuery(query); ResultSetMetaData rsmd = rs.getMetaData(); int cols = rsmd.getColumnC ...
  6. oracle table column names are case

    I did not write sql, more bad, but there is an oracle point of concern for double quotes in column names will ...
  7. Get oracle data table column names

    SELECT OWNER, TABLE_NAME, COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE TABLE_NAME = 'OSS_DATA'
  8. oracle how to modify the table name column name field, type to add the table Delete table row

    First, You can put a field of type varchar the name, coupled with a field to the field names for the same date ...
  9. SQL increasing Delete Change table field names

    1 to the table to add a new field alter table table_name add column_name varchar2 (20) not null (2) delete a f ...
  10. oracle delete column to modify the table to add columns to modify column

    tag: oracle modify the table; sql add columns; sql delete column; sql to modify column 1. Increase the column ...
  11. [Transfer] ALTER TABLE to increase the usage of the column. Delete column. To change column names. To change column constraints. To change the table name

    ALTER TABLE Name ALTER TABLE - change the table attribute syntax ALTER TABLE table [*] ADD [COLUMN] column typ ...
  12. Modify data in Oracle table field names

    Statement is as follows: ALTER TABLE to modify the table name RENAME COLUMN to modify table column name TO new ...
  13. The statement used to modify the table Oralce

    1. Add a new field: ALTER TABLE TABLE_NAME ADD (FIELD_NAME CHAR(1 BYTE) DEFAULT 0); ALTER TABLE TABLE_NAME ADD ...
  14. Get a list of all the column names and column numbers

    In a development process, because of the need to know in the end under the tables of a number of column names. ...
  15. Powder designer to change the script column names case

    Option Explicit ValidationMode = True InteractiveMode = im_Batch Dim mdl 'the current model 'Get the current m ...
  16. Create JavaScript dynamic table column

    <script> var pattern = / \. jpg / i; var src =''; var vLink = document.getElementsByName ("link&quo ...
  17. Adaptive Swing table column width

    Adaptive Swing table column width Share code from others to get some inspiration. 1. In order to realize adapt ...
  18. DB2 modify a table primary key as a method of automatic growth

    1) When would like to table a revised automatic growth, can the following command: Alter table <table name& ...
  19. ORA-01747: user.table.column, table.column or column description is invalid

    ORA-01747: user.table.column, table.column or column description is invalid The reason is there to use the Ora ...