1
2
3 /*
4 ** JDBC 2.0
5 **
6 ** DatabaseMetaData.getUDTs(catalog, schema, typeNamePattern, int types[])
7 **
8 ** NOT SUPPORTED
9 */
10 create procedure sp_ijdbc_getudts(
11 @table_qualifier varchar(128) = NULL,
12 @table_owner varchar(128) = NULL,
13 @type_name_pattern varchar(128),
14 @types varchar(128))
15 as
16 declare @empty_string varchar(1)
17 declare @empty_int int
18
19 select @empty_string = ''
20 select @empty_int = 0
21
22 /* not supported, return an empty result set */
23 select
24 TYPE_CAT = @empty_string,
25 TYPE_SCHEM = @empty_string,
26 TYPE_NAME = @empty_string,
27 CLASS_NAME = @empty_string,
28 DATA_TYPE = @empty_int,
29 REMARKS = @empty_string
30 where
31 1 = 2
32
exec sp_procxmode 'sp_ijdbc_getudts', 'AnyMode'
go
Grant Execute on sp_ijdbc_getudts to public
go