Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old June 18th, 2008, 03:58 AM
Authorized User
 
Join Date: Oct 2006
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
Posts: 1,649
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





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 07:30 AM
Alter Default on a Column Gert SQL Server 2000 4 November 28th, 2003 08:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.