[Resolvido] Informacoes sobre colunas da tabela

[advaldomesquita 93]

SELECT    name AS column_name,  
               TYPE_NAME(system_type_id) AS column_type, 
               max_length,
               collation_name,
               is_nullable
FROM sys.columns
WHERE object_id = OBJECT_ID('TABELA');

 

Abçs

 

A.Jr