Asked by: Suhail Sieberkroppasked in category: General Last Updated: 30th April, 2020
What is the command to describe table SQL Server?
Consequently, what is DESC command in SQL?
SQL DESC Statement (Describe Table) SQL DESC statement use for describe the list of column definitions for specified table. You can use either DESC or DESCRIBE statement. Datatype of the Column. With database size precision and If NUMERIC datatype scale.
One may also ask, what is table structure in SQL? SQL Server table structure overview. 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.
Similarly one may ask, what is the alternative for DESC in SQL?
DESC is not an SQL command, it's an SQL*Plus function - i.e., it won't work on other tools, especially if they are used to mange non-oracle databases. You can use EXEC sp_help 'my_table' as a way of getting a comparable functionality.
How do you describe a database?
A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records.