rs_helprep has been modified to display quoted identifiers as quoted. The examples illustrate how create replication definition and alter replication definition define quoted identifiers, and how rs_helprep displays these identifiers.
create table t1 (c1 int, c2 int)
create replication definition r1 with primary at ost_wasatch_08.pdb1 with all tables named t1 (c1 int, "c2" int quoted) primary key (c1)
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 t1 Replicate Owner Replicate Table -------------------- -------------------- t1 Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 "c2" "c2" int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)
alter replication definition r1 alter replicate table name "t1" quoted
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 "t1" Replicate Owner Replicate Table -------------------- -------------------- "t1" Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 "c2" "c2" int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)
alter replication definition r1 alter columns c2 not quoted
Replication Definition Name PRS Type Creation Date ---------------------------- -------------------- ---- ------------------- r1 ost_wasatch_09 Tbl Nov 11, 2008 2:28PM PDS.DB Primary Owner Primary Table -------------------- -------------------- -------------------- ost_wasatch_08.pdb1 "t1" Replicate Owner Replicate Table -------------------- -------------------- "t1" Send Min Cols. Used by Standby Min Vers Dynamic SQL SQL Stmt. Rep. -------------- --------------- -------- ----------- -------------- No No 1000 On None Col. Name Rep. Col. Name Datatype Len. Pri. Col. Searchable --------- -------------- -------- ---- --------- ---------- c1 c1 int 4 1 0 c2 c2 int 4 0 0 Function Name FString Class FString Source FString Name ------------- --------------------------- -------------- ------------ rs_delete rs_sqlserver_function_class Class Default rs_delete rs_insert rs_sqlserver_function_class Class Default rs_insert rs_select rs_sqlserver_function_class Class Default rs_select rs_select_ rs_sqlserver_function_class Class Default rs_select_ with_lock with_lock rs_truncate rs_sqlserver_function_class Class Default rs_truncate rs_update rs_sqlserver_function_class Class Default rs_update Subscriptions known at this Site 'ost_wasatch_09'. Subscription Name Replicate DS.DB Owner Creation Date ----------------- --------------- ----- ------------- (return status = 0)