Prev: Export Query into Files of 60k Records
Next: Find constraint
From: Thomas Hase on 12 Jan 2010 11:26
Hi,

can anybody tell me, how can I clone a view
with dmo or TSQL?

Thanks
From: Michael Coles on 12 Jan 2010 11:42
What do you mean by "clone" a view? You want to create an exact copy of the
view somewhere? If so, on the SQL side you might start by querying
INFORMATION_SCHEMA.VIEWS. There's a column called VIEW_DEFINITION that has
the exact DDL CREATE VIEW statement in it.

"Thomas Hase" <tohasremspam(a)freenet.de> wrote in message
news:gi8pk594sfo314dr49t3r0tjitfno15nhr(a)4ax.com...
> Hi,
>
> can anybody tell me, how can I clone a view
> with dmo or TSQL?
>
> Thanks


From: Itzik Ben-Gan on 12 Jan 2010 14:26
Or use:

SELECT OBJECT_DEFINITION(OBJECT_ID('dbo.V1', 'V'))

--
Itzik Ben-Gan | SQL Server MVP | www.SolidQ.com | www.InsideTSQL.com


"Michael Coles" <michaelcoAToptonlineDOTnet> wrote in message
news:#Yzh5Y6kKHA.1540(a)TK2MSFTNGP06.phx.gbl...
> What do you mean by "clone" a view? You want to create an exact copy of
> the view somewhere? If so, on the SQL side you might start by querying
> INFORMATION_SCHEMA.VIEWS. There's a column called VIEW_DEFINITION that
> has the exact DDL CREATE VIEW statement in it.
>
> "Thomas Hase" <tohasremspam(a)freenet.de> wrote in message
> news:gi8pk594sfo314dr49t3r0tjitfno15nhr(a)4ax.com...
>> Hi,
>>
>> can anybody tell me, how can I clone a view
>> with dmo or TSQL?
>>
>> Thanks
>
>
 | 
Pages: 1
Prev: Export Query into Files of 60k Records
Next: Find constraint