Creating/adding column description, not caption
- From: "R.V." <R.V. of the MidAtlantic@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 16 May 2005 13:28:01 -0700
I originally created an SQL 2000 database from Access 2000. I stored the
field descriptions in Access 2000 but they didn't transfer over during the
DTS.
How do I get these descriptions back into my SQL Server 2000 database?
I've generated the script and have made some changes to the SQL database,
like changing the data types and sizes. Now, I want to add in the
descriptions. I've looked at the syntax for CREATE TABLE but can't find
anything remotely close except for column_description. Even when I try to
type a description into the already created table, I get errors. I know I
must use the "EXECUTE sp_addextendedproperty ..." command code to include the
descriptions.
Is there an easier way than to go through all the tables and get every field
that has a definition? I started to create the object definition from the
analysis tool option but it does not save the table definition info. Is
there a way to save this to create a table and pull out the definitions?
.
- Follow-Ups:
- Re: Creating/adding column description, not caption
- From: Sue Hoegemeier
- Re: Creating/adding column description, not caption
- Prev by Date: Re: Dynamic DTS
- Next by Date: RE: Preventing double-loading of input files
- Previous by thread: Please HELP! text import problems.
- Next by thread: Re: Creating/adding column description, not caption
- Index(es):
Relevant Pages
|
