Update column name in sql

cmd to rename a collumn name in sql ALTER TABLE table_name RENAME COLUMN old_name TO new_name; sql rename column EXEC SP_RENAME ‘TABLE_NAME.OLD_COLUMN_NAME’,’NEW_COLUMN_NAME’ update column name in sql ALTER TABLE table_name ALTER COLUMN column_name datatype; alter table name sql — Microsoft SQL style EXEC sp_rename ‘TableOldName’, ‘TableNewName’; modify column name in tsql sp_rename ‘table_name.old_column’, ‘new_name’, ‘COLUMN’;

Update column name in sql Read More

Sql inner join

sql inner join SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; sql inner join SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;

Sql inner join Read More