Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    SQL Queries

    Uploaded by

    aftabjmi187

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    SQL Queries

    Uploaded by

    aftabjmi187
    4 views2 pages

    Original Title

    SQL_Queries

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    4 views2 pages

    SQL Queries

    Uploaded by

    aftabjmi187

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    of 2

    -- This is for the customers

    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name


    = 'customers';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'customers';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'customers';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'customers';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'customers';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'customers';

    -- This is for the employees


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'employees';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'employees';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'employees';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'employees';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'employees';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'employees';

    -- This is for the offices


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'offices';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'offices';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'offices';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'offices';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'offices';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'offices';

    -- This is for the orderdetails


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'orderdetails';
    SELECT column_name FROM information_schema.columns WHERE table_name =
    'orderdetails';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'orderdetails';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'orderdetails';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'orderdetails';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'orderdetails';

    -- This is for the orders


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'orders';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'orders';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'orders';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'orders';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'orders';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'orders';

    -- This is for the payments


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'payments';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'payments';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'payments';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'payments';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'payments';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'payments';

    -- This is for the productlines


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'productlines';
    SELECT column_name FROM information_schema.columns WHERE table_name =
    'productlines';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'productlines';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'productlines';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'productlines';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'productlines';

    -- This is for the products


    SELECT count(*) AS NumberOfColumns FROM information_schema.columns WHERE table_name
    = 'products';
    SELECT column_name FROM information_schema.columns WHERE table_name = 'products';
    SELECT column_name, data_type FROM information_schema.columns WHERE table_name =
    'products';
    SELECT column_name, column_type FROM information_schema.columns WHERE table_name =
    'products';
    SELECT column_name, is_nullable FROM information_schema.columns WHERE table_name =
    'products';
    SELECT column_name, column_key FROM information_schema.columns WHERE table_name =
    'products';

    You might also like