How Do You Use An SQL Query To Get Access To Database Field Properties?
The Structured Query Language (SQL) is used in many database platforms. Data is stored in tables in a columnar format. Each row is a “record” while each column is a “field.” Each field has certain properties which govern the type of data stored in that column. For example, “01” stored in a field with a “text” or “string” property is accepted as text. The same entry in a field with a numerical property will drop the “0” and treat the data as the number “1.” If you wish to see how a table’s fields are configured, you can use an SQL query to get access to their properties. Create a new SQL query. Use any query interface available to you in the SQL environment you are using. Type the word “DESCRIBE” in all capital letters. All SQL commands must be entirely in uppercase. This particular command does not alter the database like most SQL queries. It is instead used to get information about table design and structure. Type a space followed by the name of the table that contains the field you w
