USE master;

SELECT * FROM sys.databases;

USE OsobaVztah;

SELECT * FROM sys.tables;
SELECT * FROM sys.columns where OBJECT_NAME([Object_ID]) = 'Osoba';
SELECT * FROM sys.objects;

SELECT * FROM sys.all_columns;
SELECT * FROM sys.procedures;

USE Poliklinika;

-- Ktora tabulka ma kolko stlpcov v danej DB
SELECT t.name tab,c.name stlp FROM sys.tables t
JOIN sys.columns c ON t.Object_ID = c.object_id

USE Poliklinika;

SELECT * FROM INFORMATION_SCHEMA.TABLES;

SELECT * FROM Poliklinika.INFORMATION_SCHEMA.TABLES;
SELECT * FROM Poliklinika.sys.tables;

SELECT * FROM OsobaVztah.INFORMATION_SCHEMA.TABLES;
SELECT * FROM OsobaVztah.INFORMATION_SCHEMA.TABLE_CONSTRAINTS;
SELECT * FROM OsobaVztah.INFORMATION_SCHEMA.CHECK_CONSTRAINTS;
SELECT * FROM OsobaVztah.INFORMATION_SCHEMA.VIEWS;

SELECT * FROM OsobaVztah.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Osoba';

SELECT COLUMN_NAME,* FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Lekari';

SELECT TOP 3 * FROM SysColumns;
SELECT TOP 3 * FROM Master.dbo.SysColumns;
SELECT TOP 3 * FROM sys.columns;

SELECT count(*) FROM Master.dbo.SysColumns;
SELECT count(*) FROM SysColumns;
SELECT count(*) FROM sys.columns

USE master;
SELECT xtype, COUNT(xtype) FROM sys.sysobjects
GROUP BY xtype;