Using the create proxy_table command

Use of the create proxy_table command does not require a column list. Component Integration Services derives the column list from the metadata it obtains from the remote table.

If the object does exist, create proxy_table updates sysobjects, syscolumns, and sysindexes.