Advertisement
EvaldoMaciel

Contar quantas colunas tem uma tela do Banco de Dados #MSSQL

Sep 25th, 2018
278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. SELECT  COUNT(COLUMN_NAME) AS CONTADOR FROM information_schema.COLUMNS
  2. WHERE TABLE_CATALOG = 'nomedobanco' AND TABLE_NAME = 'tabela'
  3. GROUP BY TABLE_CATALOG
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement