How can I see table description in SQL?

Question

To show the table structure with all its column's attributes: name, datatype, primary key, default value, etc. In SQL Server, use sp_help function: In MySQL and Oracle, you can use DESCRIBE : In PostgreSQL, here is the go-to statement: In SQLite, it's as simple as this:

How do you find the description of a table?

SQL DESCRIBE TABLE is a SQL statement that is accountable for telling something about a specific table in the database. If we want to show the structure of a database table or tables in the server then, we will use the SQL command DESCRIBE or other keyword DESC, which is identical to DESCRIBE one.

What is DESC command in SQL Server?

The DESC command is used to sort the data returned in descending order.

How do I view a column description in SQL Server?

The SQL DESCRIBE COLUMN statement returns a group that describes a column in the result set of a query. QueryHandle (input). This argument must specify a numeric integer value with at least six digits of precision. The value identifies the query for which a result column is to be described.

Expert · Answer