How do I find the structure of a table in SQL?

Question

SQL Server: sp_help table_name (or sp_columns table_name for only columns)Oracle DB2: desc table_name or describe table_name. MySQL: describe table_name (or show columns from table_name for only columns)10 нояб. 2011 г.

How can you display a table structure?

- The structure of a table can be viewed using the DESCRIBE TABLE_NAME command. - Provides a description of the specified table or view. For a list of tables in the current schema, use the Show Tables command.

What is table structure in SQL?

The tables are the database objects that behave as containers for the data, in which the data will be logically organized in rows and columns format. Each row is considered as an entity that is described by the columns that hold the attributes of the entity.

Expert · Answer

- The structure of a table can be viewed using the DESCRIBE TABLE_NAME command. - Provides a description of the specified table or view. For a list of tables in the current schema, use the Show Tables command.

Expert · Answer

The tables are the database objects that behave as containers for the data, in which the data will be logically organized in rows and columns format. Each row is considered as an entity that is described by the columns that hold the attributes of the entity.

How do I find the structure of a table in SQL?

How can you display a table structure?

What is table structure in SQL?

Related Questions