EvaldoMaciel

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

Sep 25th, 2018
162
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data