16 lines
465 B
Transact-SQL
16 lines
465 B
Transact-SQL
use Envisage
|
|
go
|
|
IF (EXISTS (SELECT *
|
|
FROM INFORMATION_SCHEMA.TABLES
|
|
WHERE TABLE_NAME = 'GLAccount'))
|
|
set noexec on
|
|
begin transaction
|
|
EXEC sp_rename 'dbo.GLDepartment', 'GLAccount';
|
|
go
|
|
EXEC sp_rename 'dbo.GLDepartmentAccess', 'GLAccountAccess';
|
|
go
|
|
EXEC sp_rename 'dbo.Team.GLDepartmentId', 'GLAccountId', 'COLUMN';
|
|
go
|
|
EXEC sp_rename 'dbo.Company2GLDepartment.GLDepartmentId', 'GLAccountId', 'COLUMN';
|
|
go
|
|
commit transaction |