toagit/db2_table_info.sql

Created February 19, 2015 09:28

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/toagit/7e2c916a39fe3da94a22.js"></script>
Save toagit/7e2c916a39fe3da94a22 to your computer and use it in GitHub Desktop.

Download ZIP

DB2 for zOS　テーブル情報取得（SHEMA、DB、TABLESPACE）

Raw

db2_table_info.sql

	SELECT ＊ FROM SYSIBM.SYSTABLES
	WHERE NAME = 'tblName'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment