· 6 years ago · Jun 30, 2019, 02:20 PM
1use APIA_Repl_Sub
2go
3
4use master
5
6 IF NOT EXISTS (select * from sys.types where name = 'theReplicatedTables')
7 CREATE TYPE theReplicatedTables AS TABLE
8 ( OBJ_ID INT NOT NULL,
9 PRIMARY KEY CLUSTERED (OBJ_ID)
10 );
11
12use APIA_Repl_Sub
13go
14declare @the_tables [dbo].[theReplicatedTables]