Get Column Lists script

Total article views: 166 | Views in the last 30 days: 10

 Rate this |   Join the discussion |  Briefcase

This is a script like Column_Gitter by Rick Bolin (RickInMesa), it differs in the fact that it does not use cursors, it optionally adds the table name, it handles UDDT (User Defined Data Types) properly, and handles the new SQL Server 2000 datatypes.

Usage: Open this script in QA, Change QA to the desired Database, Edit the @TableName assignment for the desired table, Delete the Comment for the @T assignment to exclude table names from the output, Execute the script (F-5).

For the specified table, this script return 5 results: The Column names (SELECT list), the Column names with their datatypes (Table Creation List), the Column names with each assigned from an identically named variable (UPDATE SET list), a list of variables with the same names as the columns with their datatypes (DECLARE list), and a list of variables with the same names as the columns (VALUES or parameter list).

Total article views: 166 | Views in the last 30 days: 10