Technology Microsoft Software & solutions

How to Change a Table Name in Informix SQL

    • 1). Open your operating system's command line, type "dbaccess" (without quotation marks), and press "Enter" to launch the DB-Access utility.

    • 2). Press the "C" key to open the DB-Access "Connection" menu.

    • 3). Select "Connect" from the "Connection" submenu and press the "Enter" key.

    • 4). Provide your username and password when prompted, pressing "Enter" after each prompt.

    • 5). Choose your database server using the keyboard's arrow keys and then press "Enter."

    • 6). Choose your database using the keyboard's arrow keys and then press "Enter."

    • 7). Return to the main DB-Access screen and press the "Q" key to open to the "Query-language" menu.

    • 8). Select the "New" option using the keyboard's arrow keys and press "Enter."

    • 9). Type the following command:

      RENAME TABLE current.name TO new.name

      Substitute "current.name" with the current table name and "new.name" with the new name you want to apply to the table. Press "Enter" to run the command and change your table name.

Related posts "Technology : Microsoft Software & solutions"

How to Choose a Picture for a User Account and Start Menu in Windows Vista

Microsoft

How to Add Tracfone to the Start Menu

Microsoft

How to Stop the Reboot on the Blue Screen

Microsoft

How Do I Tell What Version of Windows XP I Am Using?

Microsoft

How to Make a Boot CD for Windows Vista

Microsoft

How to Move a Windows XP Installation

Microsoft

How to Install Ubuntu in VirtualBox

Microsoft

How to Fix a Problem With a System Idle Process

Microsoft

How to Add a VLK to Windows XP Home

Microsoft

Leave a Comment