Re: query to list field data types

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/20/04

Next message: Hari: "Re: No of columns in a table"
Previous message: Retna: "No of columns in a table"
In reply to: David Hepburn III: "query to list field data types"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 20 Apr 2004 09:58:28 +0530

hi david,

you can make use of any of the following system stored procedures.

  sp_columns <table_name> --to find column definition
  sp_helpindex <table_name> --to find indexes
  sp_help <table_name> complete table definition including indexes,pks/fks
etc.

  --
  Vishal
  vgparkar@yahoo.co.in

Next message: Hari: "Re: No of columns in a table"
Previous message: Retna: "No of columns in a table"
In reply to: David Hepburn III: "query to list field data types"
Messages sorted by: [ date ] [ thread ]