Saturday, December 23, 2017

How to list specific column name in the table

SELECT * FROM information_schema.columns WHERE table_catalog = 'myevo' AND table_name  = 'purchase_order' and column_name = 'batch_id'


sorted

SELECT * FROM information_schema.columns WHERE table_catalog = 'vbroker20-beta1' AND table_name  = 'vb_trade_tran' order by column_name

No comments:

Post a Comment

free online comma separating tool

https://delim.co/#