Select tablename, count(Columnname) from dbc.tables where table_neme='MYTABLE' and Database='MYDATABASE' group by MYTABLE
dbc.tables wont give column details better u check below SQL for the number of columns :
Select tablename, count(Columnname) from dbc.columns where tablename='table_name' and Databasename='Database_name' group by tablename
The Columns view will not work with extended object names. Use the modern ColumnsV view instead of the compatibility Columns view which is deprecated and will be eliminated in a future release. See the Data Dictionary Reference for details.