============

 SQL Server

============

.. contents::

   :local:

Informational schema

====================

::

  SELECT * FROM sys.tables;

  SELECT * FROM sys.views;

  SELECT * FROM sys.indexes;

  SELECT * FROM sys.types;

  SELECT * FROM information_schema.tables;

Table stats

===========

Individual table::

  EXEC sp_spaceused NAME;

All tables in a schema::

  sp_msforeachtable 'EXEC sp_spaceused [?]';

List collations

===============

::

  SELECT name, description FROM sys.fn_helpcollations();

Finding expression type

=======================

::

  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'BaseType');

  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Precision');

  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'Scale');

  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'MaxLength');

Number of bytes required to hold both the metadata and data of the value::

  SELECT SQL_VARIANT_PROPERTY(current_timestamp, 'TotalBytes');

https://learn.microsoft.com/en-us/sql/t-sql/functions/sql-variant-property-transact-sql

  SQL_VARIANT_PROPERTY (Transact-SQL).