equal
deleted
inserted
replaced
11 :: |
11 :: |
12 |
12 |
13 SELECT * FROM sys.tables; |
13 SELECT * FROM sys.tables; |
14 SELECT * FROM sys.views; |
14 SELECT * FROM sys.views; |
15 SELECT * FROM sys.indexes; |
15 SELECT * FROM sys.indexes; |
|
16 SELECT * FROM sys.types; |
16 |
17 |
17 SELECT * FROM information_schema.tables; |
18 SELECT * FROM information_schema.tables; |
18 |
19 |
19 Table stats |
20 Table stats |
20 =========== |
21 =========== |
32 |
33 |
33 :: |
34 :: |
34 |
35 |
35 SELECT name, description FROM sys.fn_helpcollations(); |
36 SELECT name, description FROM sys.fn_helpcollations(); |
36 |
37 |
|
38 Finding expression type |
|
39 ======================= |
|
40 |
|
41 :: |
|
42 |
|
43 SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'BaseType'); |
|
44 SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Precision'); |
|
45 SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Scale'); |
|
46 SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'MaxLength'); |
|
47 |
|
48 Number of bytes required to hold both the metadata and data of the value:: |
|
49 |
|
50 SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'TotalBytes'); |
|
51 |
|
52 https://learn.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql |
|
53 SQL_VARIANT_PROPERTY (Transact-SQL). |
|
54 |