No products in the cart.

  1. Homework Help
  2. CBSE
  3. Class 12
  4. Informatics Practices

Write a SQL command to view …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now
Write a SQL command to view constraints of the table.

    • Posted by Aman Sharma 5 years, 5 months ago

    CBSE > Class 12 > Informatics Practices
    • 4 answers

    Satyawan Sheoran 5 years, 5 months ago

    Desc table name

    1Thank You

    Latifur Shaikh 5 years, 5 months ago

    desc <tablename>;

    0Thank You

    Dimpal Shugani 5 years, 5 months ago

    Show table;

    1Thank You

    Shradha Malpani 5 years, 5 months ago

    Show create table <table-name>;

    0Thank You

    ANSWER
    http://mycbseguide.com/examin8/

    Related Questions

    All data types of MySQL with example

    • Posted by Prapti Dubey 1 year, 3 months ago

    CBSE > Class 12 > Informatics Practices
    • 0 answers
    Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

    • Posted by Sejal Gupta 1 year, 3 months ago

    CBSE > Class 12 > Informatics Practices
    • 0 answers
    Write a program that generates the table of a input number using for loop

    • Posted by Siya Vishwakarma 1 year, 4 months ago

    CBSE > Class 12 > Informatics Practices
    • 1 answers
    Consider a given series,M1 write a program in python pandas to create the series

    • Posted by Martina Sangchoju 1 year, 7 months ago

    CBSE > Class 12 > Informatics Practices
    • 2 answers
    Select round(6.5675,2);

    • Posted by Simran Batra 1 year, 2 months ago

    CBSE > Class 12 > Informatics Practices
    • 0 answers
    List down the average of phone number what is the coding I couldn't remember

    • Posted by Akib Chowdhury 1 year, 3 months ago

    CBSE > Class 12 > Informatics Practices
    • 1 answers
    Founder of python

    • Posted by Parth Chaudhary 1 year, 6 months ago

    CBSE > Class 12 > Informatics Practices
    • 2 answers
    what are aggregate function inSQL? Name any two

    • Posted by Arifa Meharun 1 year, 1 month ago

    CBSE > Class 12 > Informatics Practices
    • 0 answers
    Display the details of all the employees whose value is null

    • Posted by Yashika Kakkar 1 year, 3 months ago

    CBSE > Class 12 > Informatics Practices
    • 1 answers
    Write a python program to plot aa bar chart showing the no. Of books published in respective year using the following data

    • Posted by Maanyata Sharma 1 year, 7 months ago

    CBSE > Class 12 > Informatics Practices
    • 0 answers

    myCBSEguide App

    myCBSEguide

    Trusted by 1 Crore+ Students

    Install Now

    Test Generator

    Test Generator

    Create papers online. It's FREE.

    Try Now

    CUET Mock Tests

    CUET Mock Tests

    75,000+ questions to practice only on myCBSEguide app

    Install Now
    Google Play

    Download myCBSEguide App

    All Courses

    Other Websites

    CBSE Courses

    Resources

    Corporate

    NCERT Solutions

    CBSE Sample Papers

    All Content and Intellectual Property is under Copyright Protection | myCBSEguide.com ©2007-2025