Blogs about: Ms Sql Server
Featured Blog
SQL - Find all tables in the MS SQL Server DataBase that are missing specific column
select t.TABLE_CATALOG, t.TABLE_NAME, c.COLUMN_NAME from INFORMATION_SCHEMA.TABLES t left outer join INFORMATION_SCHEMA.COLUMNS c on t.TABLE_NAME = c.TABLE_NAME and c.COLUMN_NAME = ‘myColumn… more →
Ireth Anarion's Blog - Code snippets
SQL - Find all tables in the MS SQL Server DataBase that are missing specific column
irethanarion wrote 4 months ago: select t.TABLE_CATALOG, t.TABLE_NAME, c.COLUMN_NAME from INFORMATION_SCHEMA.TABLES t left outer jo … more →
SQL - Find all tables in the MS SQL Server DataBase with searched column
irethanarion wrote 4 months ago: select t.TABLE_CATALOG, t.TABLE_NAME, c.COLUMN_NAME, c.IS_NULLABLE, c.DATA_TYPE from INFORMATION_SCH … more →
SQL - Find list of all tables in MS SQL Server Database
irethanarion wrote 4 months ago: select distinct t.TABLE_CATALOG, t.TABLE_NAME from INFORMATION_SCHEMA.TABLES t left outer join INF … more →
