From: satish kumar on
greate



ciupazNoSpamGrazi wrote:

Re: Change table schema
21-Feb-08

"Tibor Karaszi" wrote:

Yeah Tibor ;-)
Thanks a lot you all.


--
Luigi
http://blogs.dotnethell.it/ciupaz/

Previous Posts In This Thread:

On Wednesday, February 20, 2008 10:37 AM
ciupazNoSpamGrazi wrote:

Change table schema
Hi all,
how can I change the schema of a single table?
(SS 2005).

Thanks a lot.

--
Luigi
http://blogs.dotnethell.it/ciupaz/

On Wednesday, February 20, 2008 10:40 AM
Tibor Karaszi wrote:

Can you explain what you mean by "change schema"?
Can you explain what you mean by "change schema"? Do you mean things like add column, drop column
etc? If so, check out ALTER TABLE.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Luigi" <ciupazNoSpamGrazie(a)inwind.it> wrote in message
news:CA6CD36F-04A9-4BBA-9341-41EAECB98700(a)microsoft.com...

On Wednesday, February 20, 2008 10:52 AM
ciupazNoSpamGrazi wrote:

Re: Change table schema
"Tibor Karaszi" wrote:


Sorry, no, I mean change the "owner" of the table, like

dbo.MyTable

to

Client.MyTable

Luigi

On Wednesday, February 20, 2008 10:52 AM
Aaron Bertrand [SQL Server MVP] wrote:

You want to move a table from one schema to another?
You want to move a table from one schema to another? The following sample
takes table_name and changes the schema from some_other_schema to dbo.

ALTER SCHEMA dbo TRANSFER some_other_schema.table_name;






"Luigi" <ciupazNoSpamGrazie(a)inwind.it> wrote in message
news:CA6CD36F-04A9-4BBA-9341-41EAECB98700(a)microsoft.com...

On Wednesday, February 20, 2008 10:55 AM
Uri Dimant wrote:

Hi TiborFinally people start mentioning the versuion they are using, so
Hi Tibor
Finally people start mentioning the versuion they are using, so perhaps if
the OP mentined SQL Server 2005 he/she really means SCHEMA ? :-))
Any way if you do mean SCHEMA

SELECT 'ALTER SCHEMA dbo TRANSFER ' + SCHEMA_NAME(schema_id) + '.' + name
FROM sys.tables
WHERE schema_id != SCHEMA_ID('dbo');




"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in
message news:useRbb9cIHA.5668(a)TK2MSFTNGP05.phx.gbl...

On Wednesday, February 20, 2008 12:26 PM
Tibor Karaszi wrote:

My bad, Luigi.
My bad, Luigi. You did phrase the question correctly, it was I who should be quiet when I'm tired.
Uri and Aaron understood what you meant. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Luigi" <ciupazNoSpamGrazie(a)inwind.it> wrote in message
news:08D9FDF2-84C5-41B8-AEFA-28CE8B45C007(a)microsoft.com...

On Thursday, February 21, 2008 3:03 AM
ciupazNoSpamGrazi wrote:

Re: Change table schema
"Tibor Karaszi" wrote:

Yeah Tibor ;-)
Thanks a lot you all.


--
Luigi
http://blogs.dotnethell.it/ciupaz/


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Control?s Default Style or Template by Extending the WPF Designer in Visual Studio 2010
http://www.eggheadcafe.com/tutorials/aspnet/d1ad0a33-d815-4083-8e97-c234fd661095/wpf-controls-default-style-or-template-by-extending-the-wpf-designer-in-visual-studio-2010.aspx
 | 
Pages: 1
Prev: Plz helpppp
Next: change table scema