tag:blogger.com,1999:blog-495177919198719500.post4787343262622487261..comments2009-06-04T16:46:54.705-07:00Comments on Microsoft Sql Server Tutorials: 8 Common Uses of the undocumented Stored Procedure...Suprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-495177919198719500.post-87388179872001421082009-06-04T16:46:54.705-07:002009-06-04T16:46:54.705-07:00This will give you the full name, the table name, ...This will give you the full name, the table name, and the schema:<br /><br /><br />Exec sp_MSForEachTable &#39;<br /> Select &#39;&#39;?&#39;&#39; as [Full Name]<br /> , PARSENAME(&#39;&#39;?&#39;&#39;,1) as [Table]<br /> , PARSENAME(&#39;&#39;?&#39;&#39;,2) as [Schema]<br /> &#39;Bob Soversnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-25775847000703535612009-04-14T06:33:00.000-07:002009-04-14T06:33:00.000-07:00Interesting post - is there a way to use that to g...Interesting post - is there a way to use that to get the schema for each table visited?Anonymousnoreply@blogger.com