Guest User

Untitled

a guest
Jul 21st, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 9.78 KB | None | 0 0
  1. MYSQL:
  2.  
  3. 0: jdbc:mysql://db/sakila> !metadata getDatabaseProductVersion
  4. 5.1.54-1ubuntu4-log
  5.  
  6. 0: jdbc:mysql://db/sakila> !metadata getDriverVersion
  7. mysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} )
  8.  
  9. 0: jdbc:mysql://db/sakila> SELECT COUNT(*) FROM sakila.customer;
  10. COUNT(*)  599
  11.  
  12. 0: jdbc:mysql://db/sakila> !metadata getIndexInfo sakila NULL customer TRUE TRUE
  13.  
  14. TABLE_CAT         sakila
  15. TABLE_SCHEM
  16. TABLE_NAME        customer
  17. NON_UNIQUE        FALSE
  18. INDEX_QUALIFIER
  19. INDEX_NAME        PRIMARY
  20. TYPE              3
  21. ORDINAL_POSITION  1
  22. COLUMN_NAME       customer_id
  23. ASC_OR_DESC       A
  24. CARDINALITY       541
  25. PAGES             0
  26. FILTER_CONDITION
  27.  
  28. 0: jdbc:mysql://db/sakila> !metadata getIndexInfo sakila NULL customer FALSE FALSE
  29.  
  30. TABLE_CAT         sakila
  31. TABLE_SCHEM
  32. TABLE_NAME        customer
  33. NON_UNIQUE        FALSE
  34. INDEX_QUALIFIER
  35. INDEX_NAME        PRIMARY
  36. TYPE              3
  37. ORDINAL_POSITION  1
  38. COLUMN_NAME       customer_id
  39. ASC_OR_DESC       A
  40. CARDINALITY       541
  41. PAGES             0
  42. FILTER_CONDITION
  43.  
  44. TABLE_CAT         sakila
  45. TABLE_SCHEM
  46. TABLE_NAME        customer
  47. NON_UNIQUE        TRUE
  48. INDEX_QUALIFIER
  49. INDEX_NAME        idx_fk_store_id
  50. TYPE              3
  51. ORDINAL_POSITION  1
  52. COLUMN_NAME       store_id
  53. ASC_OR_DESC       A
  54. CARDINALITY       4
  55. PAGES             0
  56. FILTER_CONDITION
  57.  
  58. TABLE_CAT         sakila
  59. TABLE_SCHEM
  60. TABLE_NAME        customer
  61. NON_UNIQUE        TRUE
  62. INDEX_QUALIFIER
  63. INDEX_NAME        idx_fk_address_id
  64. TYPE              3
  65. ORDINAL_POSITION  1
  66. COLUMN_NAME       address_id
  67. ASC_OR_DESC       A
  68. CARDINALITY       541
  69. PAGES             0
  70. FILTER_CONDITION
  71.  
  72. TABLE_CAT         sakila
  73. TABLE_SCHEM
  74. TABLE_NAME        customer
  75. NON_UNIQUE        TRUE
  76. INDEX_QUALIFIER
  77. INDEX_NAME        idx_last_name
  78. TYPE              3
  79. ORDINAL_POSITION  1
  80. COLUMN_NAME       last_name
  81. ASC_OR_DESC       A
  82. CARDINALITY       541
  83. PAGES             0
  84. FILTER_CONDITION
  85.  
  86.  
  87.  
  88. ORACLE:
  89.  
  90. 0: jdbc:oracle:thin:@db> !metadata getDatabaseProductVersion
  91. Oracle DATABASE 11g Release 11.1.0.0.0 - Production
  92.  
  93. 0: jdbc:oracle:thin:@db> !metadata getDriverVersion
  94. 10.2.0.5.0
  95.  
  96. 0: jdbc:oracle:thin:@db> SELECT COUNT(*) FROM HR.COUNTRIES;
  97. COUNT(*)  25
  98.  
  99. 0: jdbc:oracle:thin:@db> !metadata getIndexInfo NULL HR COUNTRIES TRUE TRUE
  100. TABLE_CAT
  101. TABLE_SCHEM       HR
  102. TABLE_NAME        COUNTRIES
  103. NON_UNIQUE        0
  104. INDEX_QUALIFIER
  105. INDEX_NAME
  106. TYPE              0
  107. ORDINAL_POSITION  0
  108. COLUMN_NAME
  109. ASC_OR_DESC
  110. CARDINALITY       25
  111. PAGES
  112. FILTER_CONDITION
  113.  
  114. TABLE_CAT
  115. TABLE_SCHEM       HR
  116. TABLE_NAME        COUNTRIES
  117. NON_UNIQUE        0
  118. INDEX_QUALIFIER
  119. INDEX_NAME        COUNTRY_C_ID_PK
  120. TYPE              1
  121. ORDINAL_POSITION  1
  122. COLUMN_NAME       COUNTRY_ID
  123. ASC_OR_DESC
  124. CARDINALITY       25
  125. PAGES             1
  126. FILTER_CONDITION
  127.  
  128. 0: jdbc:oracle:thin:@db>!metadata getIndexInfo NULL HR COUNTRIES FALSE FALSE
  129. Error: ORA-01031: insufficient privileges (state=42000,code=1031)
  130. java.SQL.SQLException: ORA-01031: insufficient privileges
  131.  
  132.       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
  133.  
  134.  
  135.  
  136. SQL SERVER:
  137.  
  138. 0: jdbc:jtds:sqlserver://db> !metadata getDatabaseProductVersion
  139. 10.50.1600
  140.  
  141. 0: jdbc:jtds:sqlserver://db> !metadata getDriverVersion
  142. 1.2.5
  143.  
  144. 0: jdbc:jtds:sqlserver://db> SELECT COUNT(*) FROM AdventureWorksLT.SalesLT.Customer;
  145. 847
  146.  
  147. 0: jdbc:jtds:sqlserver://db> !metadata getIndexInfo AdventureWorksLT SalesLT Customer TRUE TRUE
  148. TABLE_CAT         AdventureWorksLT
  149. TABLE_SCHEM       SalesLT
  150. TABLE_NAME        Customer
  151. NON_UNIQUE        0
  152. INDEX_QUALIFIER
  153. INDEX_NAME
  154. TYPE              0
  155. ORDINAL_POSITION  0
  156. COLUMN_NAME
  157. ASC_OR_DESC
  158. CARDINALITY       847
  159. PAGES             34
  160. FILTER_CONDITION
  161.  
  162. TABLE_CAT         AdventureWorksLT
  163. TABLE_SCHEM       SalesLT
  164. TABLE_NAME        Customer
  165. NON_UNIQUE        0
  166. INDEX_QUALIFIER   Customer
  167. INDEX_NAME        PK_Customer_CustomerID
  168. TYPE              1
  169. ORDINAL_POSITION  1
  170. COLUMN_NAME       CustomerID
  171. ASC_OR_DESC       A
  172. CARDINALITY       847
  173. PAGES             34
  174. FILTER_CONDITION
  175.  
  176. TABLE_CAT         AdventureWorksLT
  177. TABLE_SCHEM       SalesLT
  178. TABLE_NAME        Customer
  179. NON_UNIQUE        0
  180. INDEX_QUALIFIER   Customer
  181. INDEX_NAME        AK_Customer_rowguid
  182. TYPE              3
  183. ORDINAL_POSITION  1
  184. COLUMN_NAME       rowguid
  185. ASC_OR_DESC       A
  186. CARDINALITY       0
  187. PAGES             0
  188. FILTER_CONDITION
  189.  
  190.  
  191. 0: jdbc:jtds:sqlserver://db> !metadata getIndexInfo AdventureWorksLT SalesLT Customer FALSE FALSE
  192. TABLE_CAT         AdventureWorksLT
  193. TABLE_SCHEM       SalesLT
  194. TABLE_NAME        Customer
  195. NON_UNIQUE        0
  196. INDEX_QUALIFIER
  197. INDEX_NAME
  198. TYPE              0
  199. ORDINAL_POSITION  0
  200. COLUMN_NAME
  201. ASC_OR_DESC
  202. CARDINALITY       847
  203. PAGES             34
  204. FILTER_CONDITION
  205.  
  206. TABLE_CAT         AdventureWorksLT
  207. TABLE_SCHEM       SalesLT
  208. TABLE_NAME        Customer
  209. NON_UNIQUE        0
  210. INDEX_QUALIFIER   Customer
  211. INDEX_NAME        PK_Customer_CustomerID
  212. TYPE              1
  213. ORDINAL_POSITION  1
  214. COLUMN_NAME       CustomerID
  215. ASC_OR_DESC       A
  216. CARDINALITY       847
  217. PAGES             34
  218. FILTER_CONDITION
  219.  
  220. TABLE_CAT         AdventureWorksLT
  221. TABLE_SCHEM       SalesLT
  222. TABLE_NAME        Customer
  223. NON_UNIQUE        0
  224. INDEX_QUALIFIER   Customer
  225. INDEX_NAME        AK_Customer_rowguid
  226. TYPE              3
  227. ORDINAL_POSITION  1
  228. COLUMN_NAME       rowguid
  229. ASC_OR_DESC       A
  230. CARDINALITY       0
  231. PAGES             0
  232. FILTER_CONDITION
  233.  
  234. TABLE_CAT         AdventureWorksLT
  235. TABLE_SCHEM       SalesLT
  236. TABLE_NAME        Customer
  237. NON_UNIQUE        1
  238. INDEX_QUALIFIER   Customer
  239. INDEX_NAME        IX_Customer_EmailAddress
  240. TYPE              3
  241. ORDINAL_POSITION  1
  242. COLUMN_NAME       EmailAddress
  243. ASC_OR_DESC       A
  244. CARDINALITY       0
  245. PAGES             0
  246. FILTER_CONDITION
  247.  
  248.  
  249.  
  250. POSTGRESQL:
  251.  
  252. 0: jdbc:postgresql://db> !metadata getDatabaseProductVersion
  253. 8.4.9
  254.  
  255. 0: jdbc:postgresql://db> !metadata getDriverVersion
  256. PostgreSQL 9.0 JDBC3 (build 801)
  257.  
  258. 0: jdbc:postgresql://db> SELECT COUNT(*) FROM public.orders;
  259. COUNT  12000
  260.  
  261. 0: jdbc:postgresql://db> !metadata getIndexInfo NULL public orders TRUE TRUE
  262. table_cat
  263. table_schem       public
  264. TABLE_NAME        orders
  265. non_unique        f
  266. index_qualifier
  267. index_name        orders_pkey
  268. TYPE              3
  269. ordinal_position  1
  270. column_name       orderid
  271. asc_or_desc       A
  272. cardinality       12000
  273. pages             35
  274. filter_condition
  275.  
  276. 0: jdbc:postgresql://db> !metadata getIndexInfo NULL public orders FALSE FALSE
  277. table_cat
  278. table_schem       public
  279. TABLE_NAME        orders
  280. non_unique        f
  281. index_qualifier
  282. index_name        orders_pkey
  283. TYPE              3
  284. ordinal_position  1
  285. column_name       orderid
  286. asc_or_desc       A
  287. cardinality       12000
  288. pages             35
  289. filter_condition
  290.  
  291. table_cat
  292. table_schem       public
  293. TABLE_NAME        orders
  294. non_unique        t
  295. index_qualifier
  296. index_name        ix_order_custid
  297. TYPE              3
  298. ordinal_position  1
  299. column_name       customerid
  300. asc_or_desc       A
  301. cardinality       12000
  302. pages             35
  303. filter_condition
  304.  
  305.  
  306. DB2:
  307.  
  308. 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getDatabaseProductVersion
  309. SQL09072
  310.  
  311. 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getDriverVersion
  312. 3.57.82
  313.  
  314. 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> SELECT COUNT(*) FROM DB2INST1.CUSTOMER;
  315. 1  6
  316.  
  317. 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getIndexInfo NULL DB2INST1 CUSTOMER TRUE TRUE
  318.  
  319. TABLE_CAT
  320. TABLE_SCHEM       DB2INST1
  321. TABLE_NAME        CUSTOMER
  322. NON_UNIQUE        0
  323. INDEX_QUALIFIER   DB2INST1
  324. INDEX_NAME        CUST_CID_XMLIDX
  325. TYPE              3
  326. ORDINAL_POSITION  1
  327. COLUMN_NAME       INFO
  328. ASC_OR_DESC       A
  329. CARDINALITY
  330. PAGES
  331. FILTER_CONDITION
  332.  
  333. TABLE_CAT
  334. TABLE_SCHEM       DB2INST1
  335. TABLE_NAME        CUSTOMER
  336. NON_UNIQUE        0
  337. INDEX_QUALIFIER   DB2INST1
  338. INDEX_NAME        PK_CUSTOMER
  339. TYPE              3
  340. ORDINAL_POSITION  1
  341. COLUMN_NAME       CID
  342. ASC_OR_DESC       A
  343. CARDINALITY       6
  344. PAGES             1
  345. FILTER_CONDITION
  346.  
  347. TABLE_CAT
  348. TABLE_SCHEM       DB2INST1
  349. TABLE_NAME        CUSTOMER
  350. NON_UNIQUE
  351. INDEX_QUALIFIER
  352. INDEX_NAME
  353. TYPE              0
  354. ORDINAL_POSITION
  355. COLUMN_NAME
  356. ASC_OR_DESC
  357. CARDINALITY       6
  358. PAGES             1
  359. FILTER_CONDITION
  360.  
  361. 0: jdbc:db2://datisi.LOCAL:50002/SAMPLE> !metadata getIndexInfo NULL DB2INST1 CUSTOMER FALSE FALSE
  362.  
  363. TABLE_CAT
  364. TABLE_SCHEM       DB2INST1
  365. TABLE_NAME        CUSTOMER
  366. NON_UNIQUE        0
  367. INDEX_QUALIFIER   DB2INST1
  368. INDEX_NAME        CUST_CID_XMLIDX
  369. TYPE              3
  370. ORDINAL_POSITION  1
  371. COLUMN_NAME       INFO
  372. ASC_OR_DESC       A
  373. CARDINALITY
  374. PAGES
  375. FILTER_CONDITION
  376.  
  377. TABLE_CAT
  378. TABLE_SCHEM       DB2INST1
  379. TABLE_NAME        CUSTOMER
  380. NON_UNIQUE        0
  381. INDEX_QUALIFIER   DB2INST1
  382. INDEX_NAME        PK_CUSTOMER
  383. TYPE              3
  384. ORDINAL_POSITION  1
  385. COLUMN_NAME       CID
  386. ASC_OR_DESC       A
  387. CARDINALITY       6
  388. PAGES             1
  389. FILTER_CONDITION
  390.  
  391. TABLE_CAT
  392. TABLE_SCHEM       DB2INST1
  393. TABLE_NAME        CUSTOMER
  394. NON_UNIQUE        1
  395. INDEX_QUALIFIER   DB2INST1
  396. INDEX_NAME        CUST_NAME_XMLIDX
  397. TYPE              3
  398. ORDINAL_POSITION  1
  399. COLUMN_NAME       INFO
  400. ASC_OR_DESC       A
  401. CARDINALITY
  402. PAGES
  403. FILTER_CONDITION
  404.  
  405. TABLE_CAT
  406. TABLE_SCHEM       DB2INST1
  407. TABLE_NAME        CUSTOMER
  408. NON_UNIQUE        1
  409. INDEX_QUALIFIER   DB2INST1
  410. INDEX_NAME        CUST_PHONES_XMLIDX
  411. TYPE              3
  412. ORDINAL_POSITION  1
  413. COLUMN_NAME       INFO
  414. ASC_OR_DESC       A
  415. CARDINALITY
  416. PAGES
  417. FILTER_CONDITION
  418.  
  419. TABLE_CAT
  420. TABLE_SCHEM       DB2INST1
  421. TABLE_NAME        CUSTOMER
  422. NON_UNIQUE        1
  423. INDEX_QUALIFIER   DB2INST1
  424. INDEX_NAME        CUST_PHONET_XMLIDX
  425. TYPE              3
  426. ORDINAL_POSITION  1
  427. COLUMN_NAME       INFO
  428. ASC_OR_DESC       A
  429. CARDINALITY
  430. PAGES
  431. FILTER_CONDITION
  432.  
  433. TABLE_CAT
  434. TABLE_SCHEM       DB2INST1
  435. TABLE_NAME        CUSTOMER
  436. NON_UNIQUE
  437. INDEX_QUALIFIER
  438. INDEX_NAME
  439. TYPE              0
  440. ORDINAL_POSITION
  441. COLUMN_NAME
  442. ASC_OR_DESC
  443. CARDINALITY       6
  444. PAGES             1
  445. FILTER_CONDITION
Add Comment
Please, Sign In to add comment