创建表时要考虑的要点 [英] Points to be considered at the time of Creating a Table

问题描述

亲爱的朋友，

我想知道，在创建表时要考虑所有要点.
例如，主键，数据类型，大小
请指导我.
因为创建表时，我会盲目创建表和列.
但是我不知道我是用适当的程序集和结构创建的.详细信息- http://www.petri.co.il/create-tables-in-sql-server-2008-part-1.htm [ 解决方案

Go through this two part tutorial where best practices to design a new table are discussed in some detail - http://www.petri.co.il/create-tables-in-sql-server-2008-part-1.htm[^].

In my opinion, if you''re blindly creating the table, the first thing would be to forget about technical questions and to find out the business needs.

when you have gathered all of the requirements, then you can start modelling the structure, types, constraints , possible T-SQL blocks like procedures, triggers and so on.

这篇关于创建表时要考虑的要点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！