author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Sun, 19 Feb 2023 23:59:55 +0200 | |
changeset 2560 | e023a7bbaf3b |
parent 2553 | 11f741239f16 |
permissions | -rw-r--r-- |
2553 | 1 |
|
2 |
============ |
|
3 |
SQL Server |
|
4 |
============ |
|
5 |
.. contents:: |
|
6 |
:local: |
|
7 |
||
8 |
Informational schema |
|
9 |
==================== |
|
10 |
||
11 |
:: |
|
12 |
||
13 |
SELECT * FROM sys.tables; |
|
14 |
SELECT * FROM sys.views; |
|
15 |
SELECT * FROM sys.indexes; |
|
2560
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
16 |
SELECT * FROM sys.types; |
2553 | 17 |
|
18 |
SELECT * FROM information_schema.tables; |
|
19 |
||
20 |
Table stats |
|
21 |
=========== |
|
22 |
||
23 |
Individual table:: |
|
24 |
||
25 |
EXEC sp_spaceused NAME; |
|
26 |
||
27 |
All tables in a schema:: |
|
28 |
||
29 |
sp_msforeachtable 'EXEC sp_spaceused [?]'; |
|
30 |
||
31 |
List collations |
|
32 |
=============== |
|
33 |
||
34 |
:: |
|
35 |
||
36 |
SELECT name, description FROM sys.fn_helpcollations(); |
|
37 |
||
2560
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
38 |
Finding expression type |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
39 |
======================= |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
40 |
|
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
41 |
:: |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
42 |
|
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
43 |
SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'BaseType'); |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
44 |
SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Precision'); |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
45 |
SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Scale'); |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
46 |
SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'MaxLength'); |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
47 |
|
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
48 |
Number of bytes required to hold both the metadata and data of the value:: |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
49 |
|
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
50 |
SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'TotalBytes'); |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
51 |
|
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
52 |
https://learn.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
53 |
SQL_VARIANT_PROPERTY (Transact-SQL). |
e023a7bbaf3b
Finding expression type.
Oleksandr Gavenko <gavenkoa@gmail.com>
parents:
2553
diff
changeset
|
54 |