Try something like this. Hope this helps.

create table a (

col1 int)

select column_name , data_type from information_schema.columns

where table_name = 'a'

-- change col1 from int to char(10)

alter table a...

Here is a method to do it. I'm sure your situation is slightly different but maybe something similar to this might work for you:

create table test_t(

datef char(10),

timef char(8),

datetimef...

You can think of "inserted" like a table. It contains copies of the affected rows that change or are inserted during the execution of an INSERT and UPDATE statement....

We are starting to look a product call "Change Manager" by Embarcadaro. It will allow you to version your database and compare live databases to live database to report...

What system generated indexes don't start with "_WA" (although these are not really indexes, only statistics)? If you are referring to system generated primary keys then try this on...

Try this:

-- finding system generated constraint names

select name from sysobjects

where

substring(name,rtrim(len(name))-8,len(name)) like '[__][0-9,A-F][0-9,A-F][0-9,A-F][0-9,A-F][0-9,A-F][0-9,A-F][0-9,A-F][0-9,A-F]'

-- finding system genereated indexes

select name from sysindexes

where

name like '[_]WA%'