Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL:
- 0: jdbc:mysql://db/sakila> !metadata getDatabaseProductVersion
- 5.1.54-1ubuntu4-log
- 0: jdbc:mysql://db/sakila> !metadata getDriverVersion
- mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )
- 0: jdbc:mysql://db/sakila> SELECT COUNT(*) FROM sakila.customer;
- COUNT(*) 599
- 0: jdbc:mysql://db/sakila> !metadata getIndexInfo sakila NULL customer TRUE TRUE
- TABLE_CAT sakila
- TABLE_SCHEM
- TABLE_NAME customer
- NON_UNIQUE FALSE
- INDEX_QUALIFIER
- INDEX_NAME PRIMARY
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME customer_id
- ASC_OR_DESC A
- CARDINALITY 541
- PAGES 0
- FILTER_CONDITION
- 0: jdbc:mysql://db/sakila> !metadata getIndexInfo sakila NULL customer FALSE FALSE
- TABLE_CAT sakila
- TABLE_SCHEM
- TABLE_NAME customer
- NON_UNIQUE FALSE
- INDEX_QUALIFIER
- INDEX_NAME PRIMARY
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME customer_id
- ASC_OR_DESC A
- CARDINALITY 541
- PAGES 0
- FILTER_CONDITION
- TABLE_CAT sakila
- TABLE_SCHEM
- TABLE_NAME customer
- NON_UNIQUE TRUE
- INDEX_QUALIFIER
- INDEX_NAME idx_fk_store_id
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME store_id
- ASC_OR_DESC A
- CARDINALITY 4
- PAGES 0
- FILTER_CONDITION
- TABLE_CAT sakila
- TABLE_SCHEM
- TABLE_NAME customer
- NON_UNIQUE TRUE
- INDEX_QUALIFIER
- INDEX_NAME idx_fk_address_id
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME address_id
- ASC_OR_DESC A
- CARDINALITY 541
- PAGES 0
- FILTER_CONDITION
- TABLE_CAT sakila
- TABLE_SCHEM
- TABLE_NAME customer
- NON_UNIQUE TRUE
- INDEX_QUALIFIER
- INDEX_NAME idx_last_name
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME last_name
- ASC_OR_DESC A
- CARDINALITY 541
- PAGES 0
- FILTER_CONDITION
- ORACLE:
- 0: jdbc:oracle:thin:@db> !metadata getDatabaseProductVersion
- Oracle DATABASE 11g Release 11.1.0.0.0 - Production
- 0: jdbc:oracle:thin:@db> !metadata getDriverVersion
- 10.2.0.5.0
- 0: jdbc:oracle:thin:@db> SELECT COUNT(*) FROM HR.COUNTRIES;
- COUNT(*) 25
- 0: jdbc:oracle:thin:@db> !metadata getIndexInfo NULL HR COUNTRIES TRUE TRUE
- TABLE_CAT
- TABLE_SCHEM HR
- TABLE_NAME COUNTRIES
- NON_UNIQUE 0
- INDEX_QUALIFIER
- INDEX_NAME
- TYPE 0
- ORDINAL_POSITION 0
- COLUMN_NAME
- ASC_OR_DESC
- CARDINALITY 25
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM HR
- TABLE_NAME COUNTRIES
- NON_UNIQUE 0
- INDEX_QUALIFIER
- INDEX_NAME COUNTRY_C_ID_PK
- TYPE 1
- ORDINAL_POSITION 1
- COLUMN_NAME COUNTRY_ID
- ASC_OR_DESC
- CARDINALITY 25
- PAGES 1
- FILTER_CONDITION
- 0: jdbc:oracle:thin:@db>!metadata getIndexInfo NULL HR COUNTRIES FALSE FALSE
- Error: ORA-01031: insufficient privileges (state=42000,code=1031)
- java.SQL.SQLException: ORA-01031: insufficient privileges
- at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
- SQL SERVER:
- 0: jdbc:jtds:sqlserver://db> !metadata getDatabaseProductVersion
- 10.50.1600
- 0: jdbc:jtds:sqlserver://db> !metadata getDriverVersion
- 1.2.5
- 0: jdbc:jtds:sqlserver://db> SELECT COUNT(*) FROM AdventureWorksLT.SalesLT.Customer;
- 847
- 0: jdbc:jtds:sqlserver://db> !metadata getIndexInfo AdventureWorksLT SalesLT Customer TRUE TRUE
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER
- INDEX_NAME
- TYPE 0
- ORDINAL_POSITION 0
- COLUMN_NAME
- ASC_OR_DESC
- CARDINALITY 847
- PAGES 34
- FILTER_CONDITION
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER Customer
- INDEX_NAME PK_Customer_CustomerID
- TYPE 1
- ORDINAL_POSITION 1
- COLUMN_NAME CustomerID
- ASC_OR_DESC A
- CARDINALITY 847
- PAGES 34
- FILTER_CONDITION
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER Customer
- INDEX_NAME AK_Customer_rowguid
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME rowguid
- ASC_OR_DESC A
- CARDINALITY 0
- PAGES 0
- FILTER_CONDITION
- 0: jdbc:jtds:sqlserver://db> !metadata getIndexInfo AdventureWorksLT SalesLT Customer FALSE FALSE
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER
- INDEX_NAME
- TYPE 0
- ORDINAL_POSITION 0
- COLUMN_NAME
- ASC_OR_DESC
- CARDINALITY 847
- PAGES 34
- FILTER_CONDITION
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER Customer
- INDEX_NAME PK_Customer_CustomerID
- TYPE 1
- ORDINAL_POSITION 1
- COLUMN_NAME CustomerID
- ASC_OR_DESC A
- CARDINALITY 847
- PAGES 34
- FILTER_CONDITION
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 0
- INDEX_QUALIFIER Customer
- INDEX_NAME AK_Customer_rowguid
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME rowguid
- ASC_OR_DESC A
- CARDINALITY 0
- PAGES 0
- FILTER_CONDITION
- TABLE_CAT AdventureWorksLT
- TABLE_SCHEM SalesLT
- TABLE_NAME Customer
- NON_UNIQUE 1
- INDEX_QUALIFIER Customer
- INDEX_NAME IX_Customer_EmailAddress
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME EmailAddress
- ASC_OR_DESC A
- CARDINALITY 0
- PAGES 0
- FILTER_CONDITION
- POSTGRESQL:
- 0: jdbc:postgresql://db> !metadata getDatabaseProductVersion
- 8.4.9
- 0: jdbc:postgresql://db> !metadata getDriverVersion
- PostgreSQL 9.0 JDBC3 (build 801)
- 0: jdbc:postgresql://db> SELECT COUNT(*) FROM public.orders;
- COUNT 12000
- 0: jdbc:postgresql://db> !metadata getIndexInfo NULL public orders TRUE TRUE
- table_cat
- table_schem public
- TABLE_NAME orders
- non_unique f
- index_qualifier
- index_name orders_pkey
- TYPE 3
- ordinal_position 1
- column_name orderid
- asc_or_desc A
- cardinality 12000
- pages 35
- filter_condition
- 0: jdbc:postgresql://db> !metadata getIndexInfo NULL public orders FALSE FALSE
- table_cat
- table_schem public
- TABLE_NAME orders
- non_unique f
- index_qualifier
- index_name orders_pkey
- TYPE 3
- ordinal_position 1
- column_name orderid
- asc_or_desc A
- cardinality 12000
- pages 35
- filter_condition
- table_cat
- table_schem public
- TABLE_NAME orders
- non_unique t
- index_qualifier
- index_name ix_order_custid
- TYPE 3
- ordinal_position 1
- column_name customerid
- asc_or_desc A
- cardinality 12000
- pages 35
- filter_condition
- DB2:
- 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getDatabaseProductVersion
- SQL09072
- 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getDriverVersion
- 3.57.82
- 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> SELECT COUNT(*) FROM DB2INST1.CUSTOMER;
- 1 6
- 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getIndexInfo NULL DB2INST1 CUSTOMER TRUE TRUE
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 0
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME CUST_CID_XMLIDX
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME INFO
- ASC_OR_DESC A
- CARDINALITY
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 0
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME PK_CUSTOMER
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME CID
- ASC_OR_DESC A
- CARDINALITY 6
- PAGES 1
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE
- INDEX_QUALIFIER
- INDEX_NAME
- TYPE 0
- ORDINAL_POSITION
- COLUMN_NAME
- ASC_OR_DESC
- CARDINALITY 6
- PAGES 1
- FILTER_CONDITION
- 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getIndexInfo NULL DB2INST1 CUSTOMER FALSE FALSE
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 0
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME CUST_CID_XMLIDX
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME INFO
- ASC_OR_DESC A
- CARDINALITY
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 0
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME PK_CUSTOMER
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME CID
- ASC_OR_DESC A
- CARDINALITY 6
- PAGES 1
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 1
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME CUST_NAME_XMLIDX
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME INFO
- ASC_OR_DESC A
- CARDINALITY
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 1
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME CUST_PHONES_XMLIDX
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME INFO
- ASC_OR_DESC A
- CARDINALITY
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE 1
- INDEX_QUALIFIER DB2INST1
- INDEX_NAME CUST_PHONET_XMLIDX
- TYPE 3
- ORDINAL_POSITION 1
- COLUMN_NAME INFO
- ASC_OR_DESC A
- CARDINALITY
- PAGES
- FILTER_CONDITION
- TABLE_CAT
- TABLE_SCHEM DB2INST1
- TABLE_NAME CUSTOMER
- NON_UNIQUE
- INDEX_QUALIFIER
- INDEX_NAME
- TYPE 0
- ORDINAL_POSITION
- COLUMN_NAME
- ASC_OR_DESC
- CARDINALITY 6
- PAGES 1
- FILTER_CONDITION
Add Comment
Please, Sign In to add comment