Question: in SQL after the table has been created how do you add a check constraint on the column to allow only y,Y,n,N?

in SQL after the table has been created how do you add a check constraint on the column to allow only y,Y,n,N?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

FileName varchar(50) ProductID FK Products ProductID PK ProductName varchar(50) c. Now, add a new column, ProductPrice to the Products table. Use money datatype, allow null values and add a check...

Q:

Veterinarian Office Case: Part 5 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet....

Q:

Writing SQL Statements for the following tasks 1 . Create a table named yourfirstname _ store _ reps with the following columns: CREATE TABLE yourfirstname _ store _ reps ( rep _ id NUMBER ( 5 ) ,...

Q:

Instructions: For each problem Write and execute an SQL query in Oracle Live SQL or SQL * Plus Execute the following command: select sysdate, 'your name' from dual; where your _ name is substituted...

Q:

Use the cis535 database you previously created. Use T-SQL to alter the booth and machine tables. Add a foreign key constraint to each table for the product_id referencing product_id in the product...

Q:

If you would like the sql file please let me know and post your email. I'll send you the file since Chegg doesn't like links in their posts. Thanks again for the help! 3. a. Write a script that adds...

Q:

SQL - Oracle Version 4.1.4.21: Need someone to fix my answers so they run without any errors. Thnx. -------------------------------- DECLARE lv_tax_num NUMBER(2,2); BEGIN CASE 'NJ' WHEN 'VA' THEN...

Q:

Given these 3 already existing tables 1. Write a set of SQL statements (hint: Use the SQL ALTER TABLE command) to add a FullFeePaid column to ENROLLMENT and populate the column, assuming that the...

Q:

TABLE Customers-- ------------------- -- Add a Not Null constraint on LastName and FirstName by altering table and modifying the column -- Add a primary key constraint on Customers table using...

Q:

Assignment# 5 Due date: 1 0 / 0 3 / 2 0 2 4 5 : 5 9 pm Deliverable: Submit one sql file with all the sql statements for questions 1 , 2 , 3 , 4 , and 5 . Name the file yourfirstname _ yourlastName _...

Q:

Primorsk is a global specialized staffing firm. Information adapted from the statement of earnings (in thousands, without earnings per share information) in its annual report for the year ended...

Q:

The following are the major balance sheet classifications: Current assets (CA) Current liabilities (CL) Long-term investments (LTI) Long-term liabilities (LTL) Property, plant, and equipment (PPE)...

Q:

Consider a bond with a coupon of 5 . 8 percent, eleven years to maturity, and a current price of $ 1 , 0 6 2 8 0 . Suppose the yield on the bond suddenly increases by 2 percent. a . Use duration to...

Q:

A project is in the execution phase. Based on the originally approved blueprint, 1 , 0 0 0 products were developed. The project team randomly chooses 1 0 0 products to evaluate against the quality...

Q:

To what extent are you interested in, and able to contribute to social media-based interactions such as blogs, social networking sites, podcasts and so on that may provide information and ideas for...

Q:

What level of skills would you need to generate specific queries and reports from information management systems? How might you develop the skills you need? Who would be the best person to help with...

Q:

What information search skills do you need to identify and select appropriate documentary sources? How might you develop these?