spGetEmailList_ImportFields2

Parameters

Parameter	Parameter Type	Mode	Description
@ListID	int	IN

Definition

Copy



       CREATE  PROCEDURE [dbo].[spGetEmailList_ImportFields2]
      @ListID int
AS
BEGIN
      set nocount on

      declare @TABLENAME nvarchar(128);
      set @TABLENAME = dbo.fnUloadedListBuildTableName(@ListID);

      select 
            COLUMN_NAME as FieldName, 
            ORDINAL_POSITION as FieldID, 
            DATA_TYPE as DataType,
      TABLE_SCHEMA
      from INFORMATION_SCHEMA.[COLUMNS]
      where TABLE_NAME = @TABLENAME
      --and TABLE_SCHEMA = 'dbo'
      order by ORDINAL_POSITION
END