Listar los campos de una tabla de una base de datos de SQL Server

Ejecutamos esta query:

Use DEPRUEBAS

Select a.name, c.name, 
Case 
    When a.xtype = '106' then  cast(a.xprec as varchar)+ ', ' + cast(a.xscale as varchar)
    When a.xtype = '231' then  cast (a.length/2 as varchar)
    Else cast (a.length as varchar)
End as long,
Case
    When a.isnullable = 0 then 'No'
    Else 'Si'
End as isnull 
from sys.syscolumns as a 
    left join sys.tables as b On a.id = b.object_id 
    left join sys.systypes  as c on a.xtype = c.xtype and c.status = 0
Where b.name = 'datosUsuarios'

En use ponemos la base de datos que deseamos inspeccionar y en el WHERE ponemos la tabla que nos interesa:

Where b.name = 'datosUsuarios'

Y esto esto, feliz programming!!
Saludos
Alex.

Si te ha gustado el artículo compartelo en:      

---

---

---

---

---