Find all tables containing column with specified name
Here is how to find all tables containing column with specified name in sql server select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like ‘%ProductName%’ order by TABLE_NAME
Here is how to find all tables containing column with specified name in sql server select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like ‘%ProductName%’ order by TABLE_NAME
While i was working on one of the upgrade project, we were doing DB upgrade from current DB version to latest version and we faced error like ‘Invalid object name STRING_SPLIT’. Our Query was as below, [we wanted to spilt ] DECLARE @StringToSpilt NVARCHAR(50) = ‘A;B;C;D’; SELECT value FROM STRING_SPLIT(@StringToSpilt, ‘;’); Erro: Invalid object name⦠Read More »