Queries all the table names and field names in the database.

Queries all the table names and field names in the database.

SQLView All table names:
1. Select name from sysobjects
Where type = 'U'

2. Select * From information_schema.tables

Query the names of all fields in the table:
Select name from syscolumns where
Id = object_id ('table name ')

Select * From information_schema.tables
Select * from
Information_schema.views
Select * From information_schema.columns

OracleView All table names: Select table_name from
User_tables

 

AccessView All table names:
Select name from msysobjects
Where type = 1 and
Flags = 0
Msysobjects is a system object, which is hidden by default. You can use tools, options, views, displays, and system objects to display them.

Oracle Data Type

 

Field Type	Description	Restrictions	Other Instructions
Char	Fixed-length string	Maximum length 2000 Bytes
Varchar2	Variable-length string	Maximum length 4000 Bytes	Maximum index length: 749
Nchar	Character Set-based fixed-length string	Maximum length 2000 Bytes
Nvarchar2	Variable-length String Based on Character Set	Maximum length 4000 Bytes
Date	Date (day-month-year)	DD-MM-YY (HH-MI-SS)	After strict tests, no problems with insects
Long	Super long string	Maximum length2G (231-1)	Sufficient storage for big part head books
Raw	Fixed-length binary data	Maximum length 2000 Bytes	Multimedia Image sound storage
Long Raw	Variable-length binary data	Maximum length2G	Same as above
Blob	Binary data	Maximum length4G
Clob	Character data	Maximum length4G
Nclob	Character data based on character sets	Maximum length4G
Bfile	Binary data stored outside the database	Maximum length4G
Rowid	Unique row number recorded in the data table	10 bytes ********. *****. ***** format, * 0 or 1
Nrowid	The unique row number recorded in the binary data table.	Maximum length: 4000 bytes
Number (P, S)	Numeric type	P is the integer, and s is the decimal place.
Decimal (P, S)	Numeric type	P is the integer, and s is the decimal place.
Integer	Integer type	Small integer
Float	Floating Point Type	Number (38), Double Precision
Real	Real Number Type	Number (63), higher accuracy