Advanced Search

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