General SQL statement?

Once I have a table in SQLAnywhere 5.5.04, is there any way to generate 
a SQL statement that would have created it?  Someone else needs to 
recreate the structure of my table and I'd like to send them a SQL 
statement that they could use to do so.
0
rick
11/2/1999 3:40:07 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

2 Replies
497 Views

Similar Articles

[PageSpeed] 43

One way to do it is to (for example, you need foo_table TABLE):

1) unload database (can be done from Sybase Central) into foo.sql
2) copy "CREATE TABLE foo_table" command where you need it...

Petar

Rick Charnes wrote:
> 
> Once I have a table in SQLAnywhere 5.5.04, is there any way to generate
> a SQL statement that would have created it?  Someone else needs to
> recreate the structure of my table and I'd like to send them a SQL
> statement that they could use to do so.
0
Petar
11/2/1999 3:51:30 PM
>> any way to generate a SQL statement that would have created the table

If you're going to be doing this on a regular basis, I'd recommend
getting a tool like Erwin, or Powerdesigner, or System Architect that
does reverse engineering of sql databases.


0
Mike
11/2/1999 5:23:07 PM
Reply:

Similar Artilces:

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

General
Name: Andrew Email: anile_at_postmaster.co.uk Product: Minefield Summary: General Comments: The new UI is much more responsive, smaller and cleaner. The spell checking is quite amazing and will help us all with our posting like this one. I couldn't find any localised options but I'm sure they'll be implemented. Not sure about add-ons being so called, can't they be called "Extensions and Themes?" Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.9a1) Gecko/20060711 Minefield/3.0a1 (bangbang023) ...

general
Name: Darran Logie Email: hawkalmightyathotmaildotcom Product: Firefox Summary: general Comments: firefox i have always found to be excellent. All the little addons and constant refinements are always welcomed. At the moment the only thing i am missing is download manager as its not compatible with the current version. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9) Gecko/2008051206 Firefox/3.0 From URL: http://hendrix.mozilla.org/ ...

general
mailto:laura.biding@ntlworld.com ...

General
In sybase for the column what datatype the sybase expert's suggest either char or varchar? I heared that while doing update statistics ... the varchar is costlier than the space occupied by char. Please share your knowledge. Thanks and Best Regards Gopi Chand T. The choice between "varchar" and "char" doesn't have much of anything to do with the performance of "update statistics" that I know of. There is a small performance penalty for accessing variable length data on the row, but it would only be notable under very high load. Take a...

General
Hi i have some textbox and Richtext box when i type the data and click save  the data will bind to the Gridview.. I had set width for each field , Suppose while I insert data , without anyspace in the Richtextbox and click save the data binded to the gridview show Lengthy line its look so bad all alignment are changes so how shall i avoid this , else how can i insert  break line or ( space ) at the end of the each line in the richtextbox... can anyone give solution pls...  Regards,M.VenkatesanMy Blog : http://venkat-dotnetsamples.blogspot.comPlease remember to click “...

General
Sir/Madam, Please Clarify the following 1. It is possible to set edit mask for each row 2. Whether it is possible to get the column name 1. There is no change in the column (Edit changed or ItemChanged Event will not fire in this situation) 3. In PFC U_TVS when we I to update the datastore that has been registered I am getting the error integrity violation. This is because in U_TVS they are rowscopying the retrived value from an attrib to this datastore, so the status is newmodified!. I want to update the datastore by modifying the status as datamodified!. Suppo...

General
Name: Nick Product: Firefox Release Candidate Summary: General Comments: Amazing. Just needs more compatible addons and it will be wonderful. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0 From URL: http://hendrix.mozilla.org/ ...

superreview denied: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
neil@parkwaycc.co.uk <neil@httl.net> has denied Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil@httl.net> >+ <binding id="statusbarpanel-menu-iconic" display="xul:menu" extends="chrome://global/content/bindings/general.xml#statusbarpa...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 217751] (Av2) <general.xml>
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 217751: (Av2) <general.xml> https://bugzilla.mozilla.org/attachment.cgi?id=217751&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> (In reply to comment #2) > Hmm, if the diff is current (by date I would imagine so) then I do not > personally see a problem syncing this and grabbing toolkits version fr...

GENERAL SQL SERVER: Question about the Script that setups the SQL Server Database.
This is the first time I have created a script for Sql Server 2000, and I have run into a few syntax ereas that I am not familar with. Bellow is a section of the script from the Portal server packages. At the end of the sample, is "ON [PRIMARY], Can anyone explain to me what this does and why the primary key isnt setup inside the code itself? I am basically trying to take parts of the script and incorrporate it into my own script and hate added syntax that I dont understand, makes debugging a real pain in the future. CREATE TABLE [dbo].[Portal_Announcements] ( [ItemID] [in...

superreview requested: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
Serge GAUTHERIE <gautheri@noos.fr> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ------- Additional Comments from Serge GAUTHERIE <gautheri@noos.fr> Av3-XPFE-Bw, with full diff. Keeping [[ (Av3-XPFE-Bw) <general.xml>++ patch 2006-04-23 16:17 PDT 2.38 KB neil: review+ ]] ...

superreview granted: [Bug 282182] sync xpfe general.xml with toolkit general.xml : [Attachment 219626] (Av3-XPFE) <general.xml>++
neil@parkwaycc.co.uk <neil@httl.net> has granted Serge GAUTHERIE <gautheri@noos.fr>'s request for superreview: Bug 282182: sync xpfe general.xml with toolkit general.xml https://bugzilla.mozilla.org/show_bug.cgi?id=282182 Attachment 219626: (Av3-XPFE) <general.xml>++ https://bugzilla.mozilla.org/attachment.cgi?id=219626&action=edit ...

how to generalize?
DropDownList ddRegistrar=(DropDownList)e.Item.FindControl("ddRegistrar"); if(ddRegistrar!=null) { ddRegistrar.DataSource=m_RegistrarDL.Reader(); ddRegistrar.DataBind(); ddRegistrar.SelectedValue=((DataRowView)e.Item.DataItem).Row["Domain_Registrar_ID"].ToString(); } should be put in a function like but how van I generalize the following line? dd.DataSource=m_RegistrarDL.Reader(); e.g. dd.DataSource=DLs[Name].Reader(); public void DropDownList_Bind(string Name) { DropDownList dd=(DropDownList)e.Item.FindControl("dd"...

Web resources about - General SQL statement? - sybase.sqlanywhere.general

User:Jimbo Wales/Statement of principles - Wikipedia, the free encyclopedia
As we move forward with software and social changes, I think it is imperative that I state clearly and forcefully my views on openness and the ...

Category:Articles containing potentially dated statements from June 2006 - Wikipedia, the free encyclopedia ...
This is an administration category . It is used for administration of the Wikipedia project and is not part of the encyclopedia. It contains ...

Tamir Rice's Mother Comments on LeBron James Not Giving Statement on Son's Death - Bleacher Report
One week after Cleveland Cavaliers superstar LeBron James made careful comments regarding the death of Tamir Rice, the boy's mother spoke out ...

Mayor Martin Walsh’s statement on Obama gun control initiatives
Mayor Martin Walsh was in Washington, D.C. today during President Obama’s remarks on gun violence. Below is a statement from Mayor Martin Walsh, ...

Is Mark Zuckerberg’s latest post about his daughter a political statement?
... doctor. His captioned it, “ Doctor’s visit — time for vaccines! ” and the post went viral (pun possibly intended.) Seen as an official statement ...

Chipotle sued over food safety statements
Chipotle Mexican Grill was sued for allegedly misleading investors about its food safety controls.

Tesla Drivers Do ‘Crazy Things’ While Autopilot Is Engaged, Musk Issues Statement
... within two years, the Tesla will be able to be "summoned," like Lassie, from miles away.

Wheaton College moving to fire professor after Muslim statements
Wheaton College leaders are taking steps to fire the suspended political science professor who drew fire late last year for saying Christians ...

Business on Display: Making a Statement with Digital Signage
The digital signage market is projected to be worth $22 billion by 2020. Join us for our first of four webinars powered by Samsung as we discuss ...

'Affluenza' Teen's Mom's Lawyers Issue Sarcastic Statement to Sheriff
Couch's lawyers asked that proceedings to be conducted "fairly and lawfully."

Resources last updated: 1/15/2016 2:26:08 AM