Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 11 April 2017

SQL Table Drop



It is used to remove the table permanently from database along with data


Syntax:

Drop table <Table_Name>;


Example:

        DROP TABLE Student;
        DROP TABLE dept;
        DROP TABLE emp;
Share this article :

1 comments:

  1. Hi Dayakar,

    A spot on observation on what probably is “the” underlying details of the SQL Table Drop. Too many people don’t even think about wherever there will be actual demand and more importantly what happens if this demand comes later (or maybe a lot later) than they expect


    Number of times processes repeatedly query the dictionary table is called recursive hints. It is due to the data dictionary cache is too small. By increasing the SHARED_POOL_SIZE parameter we can optimize the size of data dictionary cache.

    I need help of forming a SQL query for the below situation.

    There's a table (T_BATCH_RULE) having 2 VARCHAR2(255 char) columns [BATCH_NAME, RULE_NAME]

    Assume the following data

    BATCH_NAME RULE_NAME
    B1 R1
    B1 R2
    B1 R3
    B2 R3

    Since R3 is associated to both Batch B1 and B2, I want all the rules associated with B1 to be listed as part of B2 as well.

    My output should look something like below

    BATCH_NAME RULE_NAME
    B1 R1
    B1 R2
    B1 R3
    B2 R1
    B2 R2
    B2 R3

    Please help me with the SQL query (No PL/SQL please).

    Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.

    Regards,
    Marlin

    ReplyDelete