Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Other Programming > Need help with your homework?
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Need help with your homework? Need help with a homework question on any programming language? Post questions and help here, not in the language topic forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Need help with your homework? section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 18th, 2008, 03:58 AM
Authorized User
 
Join Date: Oct 2006
Location: , , .
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default getting default value of a column

Hi All,

I have a script which extracts table from a database. I don't know if you're familiar with it, it was written by Ed Barlow. The script works fine, it can get the structure of a table from a datasource just like sp_help except for one error. The script cannot get the DEFAULT value of a column. Does anyone has tried using this script? Or is there a stored procedure I can use to get the default value of a column of a table. sp_help in Sybase also does not get the DEFAULT value of a column. Thanks!

Reply With Quote
  #2 (permalink)  
Old June 18th, 2008, 02:41 PM
Friend of Wrox
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,652
Thanks: 3
Thanked 141 Times in 140 Posts
Default

Never heard of the script.

If you don't provide a URL to it or the code for it, it's hard for us to guess at what it is doing and/or why it doesn't get the default.

Also, what database are you using??? You seem to be implying that you are using SyBase?
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Default Value for DATETIME column happygv MySQL 5 August 7th, 2009 04:14 PM
SSIS - Column Mappings Default Data Type and Size aehtra SQL Server 2005 0 April 25th, 2008 02:53 PM
Alter Column - Default Value sasidhar79 SQL Server 2000 2 January 18th, 2005 06:30 AM
Alter Default on a Column Gert SQL Server 2000 4 November 28th, 2003 07:58 AM



All times are GMT -4. The time now is 06:34 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.