sp to help create table for user defined table

ALTER  PROCEDURE [ADMIN].[GET_UDF_TABLE_INFO]

(

       @p_NAME VARCHAR(100)

)

AS

BEGIN

       BEGIN TRY

       select tt.name AS TableName, c.name AS ColumnName,st.name AS DataType

       from sys.table_types tt

              INNER JOIN sys.columns c on c.object_id = tt.type_table_object_id

              INNER JOIN sys.systypes AS ST  ON ST.xtype = c.system_type_id

       where  tt.name  = @p_NAME

  order by c.column_id

      

       END TRY

       BEGIN CATCH

              EXECUTE ADMIN.LOG_DB_ERROR;

              return 0

       END CATCH

END

 order by c.column_id is real important because ado.net is ordinal