http://www.sqle.ru/index.php?action=history&feed=atom&title=SQL_Server%2FT-SQL%2FSystem%2FINFORMATION_SCHEMA 2026-05-24T02:20:53Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/System/INFORMATION_SCHEMA&diff=5860&oldid=prev 2010-05-26T13:46:06Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://www.sqle.ru/index.php?title=SQL_Server/T-SQL/System/INFORMATION_SCHEMA&diff=5861&oldid=prev 2010-05-26T10:20:35Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Another way to test for the existence of a table==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> <br /> 4&gt;<br /> 5&gt; create table Billings (<br /> 6&gt; BankerID INTEGER,<br /> 7&gt; BillingNumber INTEGER,<br /> 8&gt; BillingDate datetime,<br /> 9&gt; BillingTotal INTEGER,<br /> 10&gt; TermsID INTEGER,<br /> 11&gt; BillingDueDate datetime ,<br /> 12&gt; PaymentTotal INTEGER,<br /> 13&gt; CreditTotal INTEGER<br /> 14&gt;<br /> 15&gt; );<br /> 16&gt; GO<br /> 1&gt;<br /> 2&gt;<br /> 3&gt; IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES<br /> 4&gt; WHERE (TABLE_NAME = &quot;Billing&quot; AND<br /> 5&gt; TABLE_TYPE = &quot;BASE TABLE&quot;))<br /> 6&gt; DROP TABLE Billing<br /> 7&gt; GO<br /> 1&gt;<br /> 2&gt; drop table Billings;<br /> 3&gt; GO<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==INFORMATION_SCHEMA.TABLES==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> <br /> 7&gt; SELECT top 10 * FROM INFORMATION_SCHEMA.TABLES<br /> 8&gt; GO<br /> TABLE_CATALOG TABLE_SCHEMA<br /> TABLE_NAME TABLE_TYPE<br /> -------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------<br /> --------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------<br /> master dbo<br /> spt_fallback_db BASE TABLE<br /> master dbo<br /> spt_fallback_dev BASE TABLE<br /> master dbo<br /> spt_fallback_usg BASE TABLE<br /> master dbo<br /> airplane BASE TABLE<br /> master dbo<br /> spt_monitor BASE TABLE<br /> master dbo<br /> spt_values BASE TABLE<br /> master dbo<br /> MSreplication_options BASE TABLE<br /> (7 rows affected)<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==Query INFORMATION_SCHEMA.VIEWS==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> <br /> <br /> 3&gt; SELECT top 10 TABLE_NAME, TABLE_SCHEMA<br /> 4&gt; FROM INFORMATION_SCHEMA.VIEWS<br /> 5&gt; GO<br /> TABLE_NAME TABLE_SCHEMA<br /> -------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------<br /> ---------------------------------------------------------<br /> titleview dbo<br /> vwProductList dbo<br /> vV dbo<br /> <br /> (3 rows affected)<br /> 1&gt;<br /> &lt;/source&gt;</div>

Admin