Skip to main content
Known Participant
Dec 6, 2023 11:24 AM UTC
Question

sql scripts for the tables created

I  have created tables in dev but i don't have the sql scripts of those tables .is there a way to retrieve those sql scripts

    3 replies

    stefanhelzle0001
    Brainy
    Dec 6, 2023 11:36 AM UTC

    You can get the scripts from the cloud database UI. Check the documentation on PHPMyAdmin for details.

    davidj137213
    Brainy
    Dec 6, 2023 11:57 AM UTC

    IF you are in cloud database, select the option Export in the database administrator. If you select Quick, it will export only data , and if you select custom, you will be able to export DDL and data.

    annap0005
    Participating Frequently
    Dec 7, 2023 6:38 AM UTC

    run this query,

    SHOW CREATE TABLE tableName;