Purchase Solution

Create a SQL alter table statement to change the name of a column

Not what you're looking for?

Ask Custom Question

I have a SQL database table dbo.Mytable which has a column WhatsUpDude.
I need an ALTER Table statement written that will assign the default value of the Windows user name to the WhatsUpDude column.

Purchase this Solution
Solution Summary

The expert creates a SQL alter table statement to change the name of a column.

Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

View More Free Quizzes
Related BrainMass Solutions

  • Oracle Sqlplus

    MODIFY command to change the size of any column in the table created in Problem 1. 5. Use the ALTER TABLE ... DROP COLUMN command to drop a column in the table created in Problem 1. 6. Rename the table created in Problem 1 using the RENAME ...

  • Creating Tables Using SQL Server

    Alter the Employees table, and add a column: o Employees table Column Name Datatype Primary Key (Y/N) Nullable (Y/N) DepartmentID Integer N Y 6. Alter the Employee table to establish a foreign key between Employees and Departments.

  • Oracle Deletion of Fields

    alter table table_name drop column column_name For example: alter table emp drop column basic ; Note that this works only in Oracle 8i; otherwise you have to copy the original table into a new table without the column you want to get rid of while

  • SQL UPDATE statement

    I need an UPDATE statement written that would appropraitely place the appropriate data in the SKUNew column. 1. add column "skunew" to the table ALTER TABLE IStock ADD SKUNew varchar(20) 2. update statement to fill the SKUNew column UPDATE IStock

  • Trigger - Update item price in SQL server 2008

    2008 -- --I need to create a trigger that will update only the price column for all 20 items in the table with its new price and this need to be executed all at one time. -- --The table name is: dbo.ITEM, column name is : price -- --I have provided

  • The Appearance of the Relation Result

    Finally, the JOIN statement combines the two tables to create one table. The results are as follows: a.

  • Structured Query Language (SQL) Preliminaries

    (4) MIN: obtains the minimum value of a column in a table. 5. Write the SELECT statement to display all the columns of the STUDENT table but only those rows where the grade column is greater than or equal to 90.

  • How to Create a Database using SQLite

    If you're entering it via the command line, the command is called "ALTER TABLE" and has this kind of syntax: "ALTER TABLE yourtablename ADD COLUMN deleted_date datatypeofcolumn".

  • Database Systems SQL Statement Examples

    UPDATE STUDENT SET Name = 'Parkerson' WHERE StudentID = 150 The above UPDATE statement will change the value of the column Name from Parker to Parkerson in ONLY one record or row, because Parker was StudentID 150.

View More Related Solutions