1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Cerrena [4.2K]
2 years ago
8

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
Universal Containers (UC) has multi-level account hierarchies that represent departments within their major Accounts. Users are
Nat2105 [25]

Answer:

The answer is "first and the last choice".

Explanation:

For providing single contact across all department the Universal Containers (UC) uses two methods, that can be defined as follows:

  • It uses the standardized contact in data, that helps to identify multiple copies, of the Information and convert it into standardized contact information.  
  • It uses the third-party tool, which helps to merge the duplicate contact information through accounts.
3 0
3 years ago
5. Question<br> The control flag that isn't really in use by modern networks is the<br> flag.
Temka [501]

Answer:

The URG flag is a control flag which is not in use by the modern networks. Explanation: When a data has been prioritized within a segment and is required urgently, URG flag is being used.

8 0
3 years ago
when you sent email your email can be set to automatically keep a copy where do you find these copies​
Strike441 [17]

Answer:

It depends on the mail service, but usually there should be a "sent" category.

Explanation:

Under "drafts" there should be an option to "show more" click that then scroll down to sent. from there you should be able to see any email sent from your account.

7 0
2 years ago
Why is a class called a factory of objects
zhenek [66]

Explanation:

A class is called an object factory because objects are created from a class. An object is an instance of a class.

4 0
3 years ago
What is commodity? explain
timama [110]
A raw material or primary agricultural product that can be bought and sold, such as copper or coffee.
6 0
3 years ago
Other questions:
  • Does Logarithms and Algorithms same things?
    6·1 answer
  • An unwanted 'explosion' of inbox messages is called​
    8·2 answers
  • When planning the structure of a spreadsheet, columns are for _______ items and rows are for _______ items.
    5·2 answers
  • Given the variable ip, already declared as a pointer to an integer, write the code to dynamically allocate memory for a single i
    15·1 answer
  • The Rule of Thirds is a way to:
    14·1 answer
  • I WILL GIVE BRAINLIEST TO WHO ANSWERS FIRST AND CORRECTLY.
    8·1 answer
  • Bored can you talk to me
    5·2 answers
  • Sharon must give an informative presentation to a group of teenagers about cultivating earthworms for use in home gardening. Whi
    11·2 answers
  • ! (( i &gt; ( f + 1)) es verdadero o falso segun la logica de programación.
    14·1 answer
  • When a ____________ file is opened, it appears full-screen, in slideshow mode, rather than in edit mode.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!