Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.