1 create table #results_table(-- 0 Rows, Data: 0 B, Index: 0 B
2 TABLE_CATALOG varchar(32) null,
3 TABLE_SCHEMA varchar(32) null,
4 TABLE_NAME varchar(255) null,
5 COLUMN_NAME varchar(255) null,
6 COLUMN_GUID varchar(36) null,
7 COLUMN_PROPID int null,
8 ORDINAL_POSITION int null,
9 COLUMN_HASDEFAULT bit not null,
10 COLUMN_DEFAULT varchar(255) null,
11 COLUMN_FLAGS int null,
12 usertype int null,
13 IS_NULLABLE bit not null,
14 DATA_TYPE smallint null,
15 TYPE_GUID varchar(36) null,
16 CHARACTER_MAXIMUM_LENGTH int null,
17 CHARACTER_OCTET_LENGTH int null,
18 NUMERIC_PRECISION smallint null,
19 NUMERIC_PRECISION_RADIX smallint null,
20 TYPE_NAME varchar(255) null,
21 NUMERIC_SCALE smallint null,
22 DATETIME_PRECISION int null,
23 CHARACTER_SET_CATALOG varchar(32) null,
24 CHARACTER_SET_SCHEMA varchar(32) null,
25 CHARACTER_SET_NAME varchar(255) null,
26 COLLATION_CATALOG varchar(32) null,
27 COLLATION_SCHEMA varchar(32) null,
28 COLLATION_NAME varchar(32) null,
29 DOMAIN_CATALOG varchar(32) null,
30 DOMAIN_SCHEMA varchar(32) null,
31 DOMAIN_NAME varchar(32) null,
32 DESCRIPTION varchar(32) null,
33 tds_type smallint null,
34 id int null,
35 col_len int null,
36 sys_type smallint null,
37 row_id numeric(10, 0) identity not null
38 )
39
QUERIES |
Joined With | Links |