Return to Snippet

Revision: 17889
at September 16, 2009 10:44 by marcocs


Initial Code
DECLARE @TableName sysname;
SELECT @TableName = 'Users'

SELECT  c.column_id ,
        c.name ,
        sys.types.name ,
        c.is_nullable
FROM    sys.columns c INNER JOIN sys.types ON c.system_type_id = sys.types.system_type_id
WHERE   OBJECT_NAME(c.object_id) = @TableName
ORDER BY c.column_id

Initial URL


Initial Description
Simple but...

Initial Title
All Columns in a Table

Initial Tags


Initial Language
SQL