All categories

2 years ago

How can structure of a table change in sql. What general types of changes are possible

Computers and Technology

1 answer:

Amiraneli [1.4K]2 years ago

7 0

One can structure of a table change in sql and the general types of changes that are possible is that:

One can use the MODIFY STRUCTURE to alter the structure of the current table that one is in and this is done by adding or deleting fields.
One can also change or alter a field name, width, or that of the data type and this is done by Issuing the MODIFY STRUCTURE command that tends to opens the Table designer, an interactive place in which a person can create or change the structure of a table.

<h3>How can we modify the structure of a table in SQL?</h3>

The SQL ALTER TABLE command is known to be the tool that is often used to alter the structure of an existing table.

Note that it is one that can helps to add or delete columns, make or destroy indexes, alter the type of existing columns, and others.

Hence, One can structure of a table change in sql and the general types of changes that are possible is that:

One can use the MODIFY STRUCTURE to alter the structure of the current table that one is in and this is done by adding or deleting fields.
One can also change or alter a field name, width, or that of the data type and this is done by Issuing the MODIFY STRUCTURE command that tends to opens the Table designer, an interactive place in which a person can create or change the structure of a table.

Learn more about table structure from

brainly.com/question/26125587

#SPJ1

You might be interested in

When an important file is saved on two different computers, what is the name of the file that is housed on the second computer?

OleMash [197]

When an important file is saved on two different computers, the name of the file that is housed on the second computer is 'back up'. Back up refers to the process of copying and archiving a particular computer data in order to have an extra copy to fall back on in the event of data loss. <span />

5 0

3 years ago

What is microsoft certification?

BabaBlast [244]

Microsoft certification is a series of programs that provide certification of competence in Microsoft products.

6 0

3 years ago

The Zootopia Police Department is recruiting new officers and has come up with an innovative equation to hire. They define hireS

Dahasolnce [82]

Answer:

#include<iostream>

#include<limits>

#include<iomanip>

using namespace std;

//function that returns true

//if there is invalid input like giving string as input

// for integer value.

bool isInvalidInput()

{

//return true if cin.fail

if(cin.fail())

{

//clear the buffer

cin.clear();

cin.ignore(numeric_limits<streamsize>::max(),'\n');

return true;

}

return false;

}

//function that calculates the hire score for given 3 parameters.

double calHireScore(double agility,double strength,double speed)

{

return (1.8*agility) + (2.16 * strength) + (3.24 * speed);

}

//calculate hire score for fox.

void calFoxHireScore()

{

double agility,strength;

cout<<"Enter Agility Value: ";

//get agility as input and validate it.

cin >> agility;

if(isInvalidInput() || agility <= 0)

{

cout<<"\nError: Agility value must be > 0"<<endl;

return;

}

cout<<"Enter Strength Value: ";

cin >> strength;

if(isInvalidInput() || strength <= 0)

{

cout<<"\nError: Strength value must be > 0"<<endl;

return;

}

cout<<"\nHire Score for Fox: "<<calHireScore(agility,strength,0)<<endl;

}

//function that asks input from user for

//calculating hire score for Sloth.

void calSlothHireScore()

{

double strength,speed;

cout<<"Enter Strength Value: ";

cin >> strength;

if(isInvalidInput() || strength <= 0)

{

cout<<"\nError: Strength value must be > 0"<<endl;

return;

}

cout<<"Enter Speed Value: ";

cin >> speed;

if(isInvalidInput() || speed <= 0)

{

cout<<"\nError: Speed value must be > 0"<<endl;

return;

}

cout<<"\nHire Score for Sloth: "<<calHireScore(0,strength,speed)<<endl;

}

//function that asks input from user for

//calculating hire score for Bunny.

void calBunnyHireScore()

{

double agility,speed;

cout<<"Enter Agility Value: ";

cin >> agility;

if(isInvalidInput() || agility <= 0)

{

cout<<"\nError: Agility value must be > 0"<<endl;

return;

}

cout<<"Enter Speed Value: ";

cin >> speed;

if(isInvalidInput() || speed <= 0)

{

cout<<"\nError: Speed value must be > 0"<<endl;

return;

}

cout<<"\nHire Score for Bunny: "<<calHireScore(agility,0,speed)<<endl;

}

//function to display menu for user.

void menu()

{

cout<<"\n1. Fox"<<endl;

cout<<"2. Bunny"<<endl;

cout<<"3. Sloth"<<endl;

cout<<"0. Quit"<<endl;

cout<<"Enter your choice: ";

}

//main method

int main()

{

int choice;

{

//asks choice

menu();

cin >> choice;

//if invalid input print erro message

if(isInvalidInput())

{

cout<<"\nError: Invalid choice enetered. Try Again\n";

}

else

{

cout<<"\n";

//if any one of the choices do accordingly

//for invalid choice print error mesage.

switch(choice)

{

case 1:

calFoxHireScore();

break;

case 2:

calBunnyHireScore();

break;

case 3:

calSlothHireScore();

break;

case 0:

cout<<"\nQutting...\n";

break;

default:

cout<<"Invalid choice entered."<<endl;

break;

}

}while(choice != 0);

return 0;

}

Explanation:

3 0

4 years ago

Gabe wants to move text from one document to another document he should __

musickatia [10]

The best way to move text from one document to another is to copy it to the clipboard on the computer and then paste it on the new document.

In order to move the text, Gabe will need to select (highlight) the text that he wants to copy and then copy it. He can copy it by clicking on the copy icon or right click and choose copy. This step places the text on the clipboard. The next step is to place the cursor in the new document and then click the paste icon or right click and choose paste. This will move the text from one document to another.

3 0

3 years ago

Read 2 more answers

If a user's input string matches a known text message abbreviation, output the unabbreviated form, else output: Unknown. Support

Molodets [167]

Answer:

Here is the JAVA program. I have added a few more abbreviations apart from LOL and IDK.

import java.util.Scanner; // to take input from user

public class MessageAbbreviation {

public static void main(String[] args) { //start of main() function body

Scanner input = new Scanner(System.in); // create object of Scanner

String abbreviation= ""; //stores the text message abbreviation

/* In the following lines the abbreviation string type variables contain the un-abbreviated forms */

String LOL = "laughing out loud";

String IDK = "i don't know";

String BFF = "best friends forever";

String IMHO = "in my humble opinion";

String TMI = "too much information";

String TYT = "take your time";

String IDC = "I don't care";

String FYI = "for your information";

String BTW = "by the way";

String OMG = "oh my God";

//prompts the user to enter an abbreviation for example LOL

System.out.println("Input an abbreviation:" + " ");

if(input.hasNext()) { // reads the abbreviation form the user

abbreviation= input.next(); }

// scans and reads the abbreviation from user in the abbreviation variable

/*switch statement checks the input abbreviation with the cases and prints the un abbreviated form in output accordingly. */

switch(abbreviation) {

case "LOL" : System.out.println(LOL);

break;

case "IDK" : System.out.println(IDK);

break;

case "BFF" : System.out.println(BFF);

break;

case "IMHO": System.out.println(IMHO);

break;

case "TMI": System.out.println(TMI);

break;

case "TYT": System.out.println(TYT);

break;

case "IDC": System.out.println(IDC);

break;

case "FYI": System.out.println(FYI);

break;

case "BTW": System.out.println(BTW);

break;

case "OMG": System.out.println(OMG);

break;

default : System.out.println("Unknown"); } } }

Explanation:

The program first prompts the user to enter an abbreviation. Lets say the user enters LOL. Now the switch statement has some cases which are the conditions that are checked against the input abbreviation. For example if the user enters LOL then the following statement is executed:

case "LOL" : System.out.println(LOL);

This means if the case is LOL then the message ( un abbreviated form) stored in the LOL variable is displayed on output screen So the output is laughing out loud.

Anything else entered other than the given abbreviations will display the message: Unknown

The output is attached as screen shot.

5 0

3 years ago

Read 2 more answers