Shulou(Shulou.com)05/31 Report--

How to modify field properties in SQLServer database, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

How to modify field properties in SQLServer database

1: add fields to the table

Altertable [table name] add [column name] type

2: delete field

Altertable [table name] dropcolumn [column name]

3: modify the field type in the table (you can modify the type of the column, whether it is empty)

Altertable [table name] altercolumn [column name] type

4: add primary key

Altertable [Table name] addconstraint [constraint name] primarykey ([column name])

5: add unique constraints

Altertable [Table name] addconstraint [constraint name] unique ([column name])

How to modify field properties in SQLServer database

6: add a default value for a column in the table

Altertable [Table name] addconstraint [constraint name] default (default) for [column name]

7: add constraints

Altertable [Table name] addconstraint [constraint name] check (content)

8: add a foreign key constraint

Altertable [Table name] addconstraint [constraint name] foreignkey (column name) referencese another table name (column name)

9: delete constraint

Altertable [table name] addconstraint [constraint name]

10: rename the table

Execsp_rename' [original table name]','[new table name]'

11: rename column names

Execsp_rename' [table name]. [column name]','[table name]. [new list]'

This is the answer to the question about how to modify the field properties in the SQLServer database. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.