SQL command to view columns of the specified table


SELECT column_name,data_type, character_maximum_length
FROM information_schema.columns
WHERE table_name   = '<your table name>'

This command usually works in many database engines.

Popular posts from this blog

npm refusing to install as a dependency of itself

How to call javascript functions from VB.NET and using WebBrowser Control