EnVisageOnline/Main/Database/Scripts/20150120/01_client_add_glaccount.sql

8 lines
233 B
Transact-SQL

USE [EnVisage]
GO
ALTER TABLE [dbo].[Client] ADD [GLAccountId] [uniqueidentifier] NULL
GO
ALTER TABLE [dbo].[Client] WITH CHECK ADD CONSTRAINT [FK_Client_GLAccount] FOREIGN KEY([GLAccountId])
REFERENCES [dbo].[GLAccount] ([Id])
GO