set . For usage information, see Section 14.16.2.1, “Using InnoDB Transaction and Locking Information”. The COLUMNS table has these columns: how to modify a column size, if we have multiple tables with different suffix and thay all contains same column definations, i need to modify a specific column's size of all tables using one script. See Chapter 33, The INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS Table. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. Retrieving information about primary keys may require joining a couple of these views. The INFORMATION_SCHEMA views are SQL-92 ANSI standard conforming views with database metadata, data which describes the database itself. Here is a view of table columns in Oracle SQL Developer: You could also get this. The recommended way to retrieve information about your database, tables or columns is to use the INFORMATION_SCHEMA views. Although some differ in what information you can get out, at least it's a consistent place to look. The Snowflake Information Schema (aka “Data Dictionary”) consists of a set of system-defined views and table functions that provide extensive metadata information about the objects created in your account. I think INFORMATION_SCHEMA works on just about every major database I've seen. The COLUMNS table provides information about columns in tables. Scope of rows: (A) all columns of tables accessible to the current user in Oracle database, (B) all columns in tables in Oracle database; Ordered by schema name, table name, column sequence number; Sample results. The views are the same in SQL Server, Sybase, ORACLE and IBM DB2. For SQL Server 2008, we can use information_schema.columns for getting column information. SELECT * FROM information_schema.columns WHERE table_name = 'Table_Name' ORDER BY ordinal_position ... Official documentation on ALL_TAB_COLUMNS via the official Oracle Database Reference. In relational databases, the information schema (information_schema) is an ANSI-standard set of read-only views that provide information about all of the tables, views, columns, and procedures in a database. Examples Example 1: The following example retrieves table metadata for all of the tables in the dataset named mydataset.The query selects all of the columns from the INFORMATION_SCHEMA.TABLES view except for is_typed, which is reserved for future use.The metadata returned is for all tables in mydataset in your default project — myproject.. mydataset … echo “COPY (SELECT * FROM information_schema.columns where table_schema = ‘public’ order by table_name, column_name asc ) TO STDOUT WITH DELIMITER AS ‘,’ NULL AS ‘NULL’ CSV HEADER;” | /opt/sfmdb/pgsql/bin/psql -o ${SCHEMACSV} For a table in oracle, I can query "all_tab_columns" and get table column information, like the data type, precision, whether or not the column is nullable. These views were introduced in the SQL-92 standard, and all database vendors have adopted or will soon adopt this standard. Different RDBMS provides system views with information about all the columns and their definitions in the database tables SQLServer : SYS.COLUMNS (Microsoft) INFORMATION_SCHEMA.COLUMNS (ANSI SQL)Oracle : ALL_TAB_COLUMNS (ANSI SQL)My Sql : INFORMATION_SCHEMA.COLUMNS (ANSI SQL) Microsoft SQL server's INFORMATION_SCHEMA.COLUMNS is equivalent to ALL_TAB_COLUMNS in oracle and INFORMATION_SCHEMA … Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this table, including data types and default values. as like mentioned below: update . It can be used as a source of the information that some databases make available through non-standard commands, such as: the SHOW command of MySQL information_schema.columns. Here is an example that extracts all table/column metadata from a postgresql database into a CSV file. In SQL Developer or TOAD, you can click on a view in the GUI and it will spit out a list of the columns that the view returns and the same set of data (data type, precision, nullable, etc). character_maximum_length = 100, character_octet_length = 100. where