How can you display a table structure?

Question

- 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.

How do you display the structure of a table in SQL?

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)

Which command will display the structure of table pet?

The command for seeing the structure of a table in MySQL is: DESCRIBE my_table_name.

Expert · Answer

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)

Expert · Answer

The command for seeing the structure of a table in MySQL is: DESCRIBE my_table_name.

How can you display a table structure?

How do you display the structure of a table in SQL?

Which command will display the structure of table pet?

Related Questions