tag:blogger.com,1999:blog-495177919198719500.post879720776986397922..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Retrieve all Tables in a Database as DatabaseName.Schema.TableNameSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-495177919198719500.post-85190027322480324862010-02-03T23:43:00.980-08:002010-02-03T23:43:00.980-08:00It is better practice not to query against system ...It is better practice not to query against system tables. Use Information_schema views instead<br /><br />The same can be done by<br /><br /><br /><br />select table_catalog+'.'+table_name from information_schema.tables<br />where table_type='BASE TABLE'Unknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.com