Answered: Use SQL to make the following changes…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Use SQL to make the following changes to the Henry Books database (Figures 1-4 through 1-7 in Chapter 1). After each change, execute an appropriate query to show that the change was made correctly. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output.

Change the length of the TITLE column in the FICTION table to 50 characters.

Expert Solution

Step 1

Syntax to alter a column in a table is:

ALTER TABLE table_name ALTER COLUMN column_name datatype;

To change the length of the TITLE column in the FICTION table to 50 characters, run the following query:

In SQL Server:

ALTER TABLE FICTION ALTER COLUMN TITLE varchar(50)

IN MySQL:

ALTER TABLE FICTION MODIFY TITLE varchar(50)

Step by step

Solved in 2 steps

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions