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:

frez [133]2 years ago

3 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

Case 1-1Tom has just started working as an intern for a local radio station. He is responsible for managing the request line and

pantera1 [17]

Answer:

The answer is Live Preview.

Explanation:

Live Preview is a Powerpoint tool that helps the user to find out how a singular choice will change the appearance of the presentation, without committing any change. This application allows the user to edit any slide and see the changes without any risk of damaging the rest of the presentation.

It lets the user see how an actual change will look on the slide object before the user decides to accept or decline the change.

It is a powerful resource, because we know how handful it is to prepare a powerpoint presentation.

3 0

3 years ago

For each problem listed below, use the drop-down menu to select the field of the professional who can help solve the issue.

Paul [167]

Answer:

Interactive media

Information services and support

Programming and software development

Network systems administration

Explanation:

The company has finished designing a software program, but users aren’t sure how to use it. interactive media

Several people in the human resources department need new software installed. information services and support

An employee has an idea for a software program that can save the company time, but doesn’t know how to write it.  programming and software development

A new branch of the company is opening soon, and the computers there need to be connected to the Internet. network systems administration

OAmalOHopeO

3 0

3 years ago

Discuss different types of data?[At the language of computer information and technology system]

Artist 52 [7]

Answer:

n computer science and computer programming, a data type or simply type is an attribute of data which tells the compiler or interpreter how the programmer intends to use the data. Most programming languages support basic data types of integernumbers (of varying sizes), floating-point numbers (which approximate real numbers), characters and Booleans. A data type constrains the values that an expression, such as a variable or a function, might take. This data type defines the operations that can be done on the data, the meaning of the data, and the way values of that type can be stored. A data type provides a set of values from which an expression(i.e. variable, function, etc.) may take its values.[1][2]

8 0

3 years ago

Which statement draws an accurate comparison between social media marketing and conventional marketing? Social media marketing i

wlad13 [49]

I think the best answer would be the last option. Social media allow customers to express their views while conventional media do not. In social media, the viewers can freely right their comments and testimonials about a product. However, in conventional marketing like advertisements in televisions, the viewers cannot make direct comments to the company.

4 0

4 years ago

Which part of project management involves determining possible risks?

stira [4]

Resources :) You’re welcome

7 0

3 years ago

Read 2 more answers