USP_EMAILLIST_GETIMPORTEDFIELDS
Returns the fields included in an imported email list.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EMAILLISTID | int | IN |
Definition
Copy
create procedure dbo.USP_EMAILLIST_GETIMPORTEDFIELDS(@EMAILLISTID int)
as
begin
declare @TABLENAME nvarchar(128);
set @TABLENAME = dbo.fnUloadedListBuildTableName(@EMAILLISTID);
select
ORDINAL_POSITION as FieldID,
COLUMN_NAME as FieldName
from INFORMATION_SCHEMA.[COLUMNS]
where TABLE_NAME = @TABLENAME
order by ORDINAL_POSITION
end