-- ინფორმაცია ცხრილების შესახებ
USE tempdb;
SELECT name, object_id, principal_id, schema_id, parent_object_id, type, type_desc, create_date, modify_date, is_ms_shipped, is_published,
is_schema_published, lob_data_space_id, filestream_data_space_id, max_column_id_used, lock_on_bulk_load, uses_ansi_nulls, is_replicated,
has_replication_filter, is_merge_published, is_sync_tran_subscribed, has_unchecked_assembly_data, text_in_row_limit,
large_value_types_out_of_row, is_tracked_by_cdc, lock_escalation, lock_escalation_desc
FROM sys.tables

-- ინფორმაცია ცხრილის სვეტების შესახებ
SELECT b.name AS TableName, b.create_date, b.modify_date, a.object_id, a.name AS ColumnName, a.column_id, a.system_type_id, a.user_type_id,
a.max_length, a.precision, a.scale, a.collation_name, a.is_nullable, a.is_ansi_padded, a.is_rowguidcol, a.is_identity, a.is_computed, a.is_filestream,
a.is_replicated, a.is_non_sql_subscribed, a.is_merge_published, a.is_dts_replicated, a.is_xml_document, a.xml_collection_id, a.default_object_id,
a.rule_object_id, a.is_sparse, a.is_column_set
FROM sys.columns AS a INNER JOIN
sys.tables AS b ON a.object_id = b.object_id
WHERE (a.object_id IN
(SELECT object_id
FROM sys.all_objects
WHERE (type_desc = 'USER_TABLE')))