To modify the field type and field name in SQL Server

To modify the field type and field name in SQL Server

--Here is the complete SQL execution statement

if exists (SELECT * from syscolumns where id=object_id (' datasheet name ') and name= ' field name ')--determine if the field exists

Begin

Alter TABLE indicates that the ALTER COLUMN field name VARCHAR (64);--Change type

End

Go

if exists (SELECT * from syscolumns where id=object_id (' table name ') and name= ' old field name ')--to determine if the field exists

Begin

EXEC sp_rename ' shows. Old field name ', ' new field name ', ' COLUMN '; --Change field name sp_rename to data stored procedure

End

Go