Check how to write the sql statement of the table structure

Xiaobian to share with you how to write sql statements to view table structure, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let us go to understand it together!

The way to view sql statements for table structure is:

Oracle View Table Structure

1. command window: desc table name

sql window: select * from user_tab_columns where table_name='upper case table name';

MySQL View Table Structure

1. View table structure: desc table name

The above is "how to write sql statements to view table structure" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!