1

Please login or register to vote for this query.

(click on this box to dismiss)

Column Rename Example

Q&A for designers and implementers of computer programming languages

SELECT 'EXEC sp_rename ''' + TABLE_NAME + '.' + QUOTENAME(COLUMN_NAME) + ''', ''' + REPLACE(REPLACE(COLUMN_NAME, 'Count', 'Cnt'), 'View', 'Vw') + ''', ''COLUMN''; ' 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%Count%' 
    OR COLUMN_NAME LIKE '%View%'

fork query

edited jun 10 2024

created may 27 10 Cade Roux