How to search all columns of all tables in a database for a keyword?

declare @SearchStr nvarchar(100)='vinh' -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved. -- Purpose: To search...

List data type của toàn database

SELECT distinct ty.name FROM sys.tables as t inner join sys.columns AS c on c.object_id = t.object_id inner join sys.types AS ty ON c.u...

Kiểm tra 1 column có tồn tại trong 1 table hay không?

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='dbo' AND TABLE_NAME = 'tableName' AND COLUMN_NAME = 'colum...

Find a column in the same table in similar databases

In project, we have a template database that deployed for many countries, these database are put in the same SQL Server instance. And toda...