मराठी
तामिळनाडू बोर्ड ऑफ सेकेंडरी एज्युकेशनएचएससी विज्ञान इयत्ता १२

Write few commands used by DBA to control the entire database. - Computer Applications

Advertisements
Advertisements

प्रश्न

Write few commands used by DBA to control the entire database.

थोडक्यात उत्तर

उत्तर

  1. USE Database-
    This command is used to select the database in MySQL for working.
    Syntax:
    mysql > use test;
    Database changed
    mysql>
  2. SHOW Databases-
    Lists all the databases available in the database server.
    Syntax:
    mysql > show databases;
  3. SHOW Tables-
    Lists all the tables available in the current database we are working in.
    Syntax:
    mysql > show tables;
  4. SHOW COLUMNS FROM tablename-
    Lists all the attributes, attribute type, Is Null value permitted, key information, default value and other information for the given table.
    Syntax:
    mysql > show columns from sports;
  5. SHOW INDEX FROM tablename-
    The query shows all the indexes for the given table.
    Syntax:
    mysql > show indexes from sports;
  6. SHOW TABLE STATUS LIKE tablename\G-
    This command provides with detailed report on the performance of the table.

shaalaa.com
Introduction to SQL
  या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 3: Introduction to Database Management System - Evaluation - PART – III [पृष्ठ ८३]

APPEARS IN

सामाचीर कलवी Computer Applications [English] Class 12 TN Board
पाठ 3 Introduction to Database Management System
Evaluation - PART – III | Q 5. | पृष्ठ ८३
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×