At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.
SELECT t.name as tablename, c.name as columnname, st.name, c.is_identity, c.is_nullable --,c.max_length, c.precision, c.scale FROM sys.tables t JOIN sys.columns c on t.object_id = c.object_id join sys.types st on c.system_type_id = st.system_type_id WHERE t.type='U' --and c.name like '%type%' ORDER BY t.name, c.column_id, c.is_identity
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.