SQL SERVER SELECT ALL TABLES FROM DATABASE

SAL SERVER SELECT QUERY FOR ALL TABLES.


select * from information_schema.tables


THIS QUERY WILL HELP YOU TO SHOW ALL TABLES FROM THE DATABASE.
FOR FIND ANY TABLE YOU CAN SELECT QUERY LIKE THIS


select * from information_schema.tables WHERE TABLE_NAME LIKE
'%_NANE%


FROM THIS QUERY YOU CAN EASILY SEARCH THE TABLE FROM YOUR DATABASE