If I would like to get a list of table name which table name has %arap%, you can use this SQL statement to do query:
SELECT NAME FROM sys.tables WHERE NAME LIKE '%arap%'
If I would like to get a list of table which has column name %apply%, you can use this SQL statement to do query:
SELECT t.NAME AS 'TableName', c.NAME AS 'ColumnName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.NAME LIKE '%apply%' ORDER BY t.NAME, c.NAME;
No comments:
Post a Comment