Common table name modifications for SQL Server

View table:exec sp_help table name

Look up columns: exec sp_columns table name

View column:Select * from information_schema.columns where table_name = ' table name '

Add column:ALTER TABLE name add column name varchar

Delete Column:ALTER TABLE table name drop Column name

Modify Column name:exec sp_rename ' table name. Field name ', ' New name ', 'column '

Modify column type:ALTER TABLE name ALTER COLUMN name varchar

Verify that this field is included

IF not EXISTS (SELECT * from syscolumns WHERE [ID] = object_id (n ' Customer ') and [NAME] = n ' accesspoint ')

EXEC sp_rename ' customer.access ', ' accesspoint ', ' column '

Common table name modifications for SQL Server