This is a multi-part message in MIME format.
------_=_NextPart_001_01C8BCAD.3DDF1CBB
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hi List,
=20
I want to create a new table with the data and constraints as it is from
existing table. I could create a new table with the existing table data
as " create table test2 as select * from test1; ". Here the constraints
are not copying. Can any one please show me the way. =20
=20
Regards,
G. V. Suresh Gupta
------------------------------------------------------------------------
---------------------------------------------------------
Innovative Technology Solutions(ITS), Zensar Technologies=20
Zensar Knowledge Park, Plot#5, MIDC IT Tower,=20
Kharadi, Off Nagar Road, Pune - 411014
Landline : +91-20-66453471 | +91-9890898688 =20
Email : suresh.g@[EMAIL PROTECTED]
| website: www.zensar.com
=20
=20
DISCLAIMER:
This email may contain confidential or privileged information for the =
intended recipient(s) and the views expressed in the same are not =
necessarily the views of Zensar Technologies Ltd. If you are not the =
intended recipient or have received this e-mail by error, its use is =
strictly prohibited, please delete the e-mail and notify the sender. =
Zensar Technologies Ltd. does not accept any liability for virus =
infected mails.=20
------_=_NextPart_001_01C8BCAD.3DDF1CBB
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"Street"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"address"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceType"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
@[EMAIL PROTECTED]
Section1
{size:8.5in 11.0in;
margin:1.0in 77.95pt 1.0in 77.95pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Hi List,<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>I want to create a new table with the data and constraints as it =
is
from existing table. I could create a new table with the existing table =
data as
“ create table test2 as select * from test1; “. Here the
constraints are not copying. Can any one please show me the way. =
<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Regards,<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>G. V. Suresh Gupta<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>-----------------------------------------------------------------=
----------------------------------------------------------------<o:p></o:=
p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Innovative Technology Solutions(ITS), Zensar Technologies =
<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><st1:place w:st=3D"on"><st1:PlaceName =
w:st=3D"on"><font
size=3D2 face=3D"Courier New"><span =
style=3D'font-size:10.0pt'>Zensar</span></font></st1:PlaceName>
<st1:PlaceName w:st=3D"on">Knowledge</st1:PlaceName> <st1:PlaceType =
w:st=3D"on">Park</st1:PlaceType></st1:place>,
Plot#5, MIDC IT Tower, <o:p></o:p></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Kharadi, Off <st1:Street w:st=3D"on"><st1:address =
w:st=3D"on">Nagar Road</st1:address></st1:Street>,
Pune – 411014<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Landline :
+91-20-66453471 &nbs=
p; |
+91-9890898688  =
;
<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'>Email :
suresh.g@[EMAIL PROTECTED]
| website: =
www.zensar.com<o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'> <o:p></o:p></span></font></p>
<p class=3DMsoPlainText><font size=3D2 face=3D"Courier New"><span =
style=3D'font-size:
10.0pt'> </span><o:p></o:p></font></p>
</div>
<p></p><p>DISCLAIMER:<br>This email may contain confidential or =
privileged information for the intended recipient(s) and the views =
expressed in the same are not necessarily the views of Zensar =
Technologies Ltd. If you are not the intended recipient or have received =
this e-mail by error, its use is strictly prohibited, please delete the =
e-mail and notify the sender. Zensar Technologies Ltd. does not accept =
any liability for virus infected mails. </body>
</html>
------_=_NextPart_001_01C8BCAD.3DDF1CBB--
|
