Tips: Create An Empty Table Has Same Columns with Existed Table

    xiaoxiao2021-12-14  19

    Sometime we need a new empty table has same columns with existed Table to store some components in, 

    But re-design a new table is a demanding task, then try this out! 

     

    select * into Testcreate from students where 1<>1 

     

    Disconnect and reconnect, what you want is already there, like magic! 

    Go check it! 

     

    转载请注明原文地址: https://ju.6miu.com/read-963339.html

    最新回复(0)