Points to be considered at the time of Creating a Table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Dear Friends,

I want to know that, at the time of creating the Table what all points to considered.
Eg- Primary Key, datatype, size
Kindly guide me on the same.
Because when I am creating a Table, I bliendly create a table and my columns.
But I dont know wheather I have created in proper set precedure and structure.

Posted 15-Aug-12 20:38pm

Arunprasath Natarajan

Add a Solution

Comments

Sergey Alexandrovich Kryukov 16-Aug-12 2:44am

Not clear. Not even a question.
--SA

Arunprasath Natarajan 16-Aug-12 4:02am

Sorry, Will improve myself next time while updating such things or que.

bbirajdar 16-Aug-12 3:12am

No offence, but blind people should take help of their senior team member while designing a database...

Arunprasath Natarajan 16-Aug-12 4:00am

Yeah I agree, tats y I ve dropped my que. here.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2012-08-15T20:42:00

Solution 1

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[^].

Posted 15-Aug-12 20:42pm

Abhinav S

Comments

Sergey Alexandrovich Kryukov 16-Aug-12 2:45am

Well, what else could be advised in case of such a vague and incorrect question? Voted 5.
--SA

Abhinav S 16-Aug-12 2:46am

Thanks SA.

Wendelius 16-Aug-12 2:52am

Good answer

Abhinav S 16-Aug-12 2:52am

Thank you Mika.

Arunprasath Natarajan 16-Aug-12 4:33am

Will get back to you aft referring the mentioned link. Tan Q.

Sergey Alexandrovich Kryukov 16-Aug-12 13:25pm

Sure.
When and if you find that it makes sense, please consider accepting the answer formally (green button) -- thanks.
--SA

Espen Harlinn 19-Aug-12 9:28am

5'ed!

Abhinav S 19-Aug-12 12:55pm

Thank you Espen.

Wendelius · Accepted Answer · 2012-08-15T20:51:00

Solution 2

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.

Posted 15-Aug-12 20:51pm

Wendelius

Comments

Abhinav S 16-Aug-12 2:53am

Fair enough. 5.

Wendelius 16-Aug-12 2:55am

Thanks Abhinav.

Arunprasath Natarajan 16-Aug-12 3:59am

Tan q, well said.

Wendelius 16-Aug-12 4:01am

You're welcome :)

Sergey Alexandrovich Kryukov 16-Aug-12 16:41pm

If so, please consider accepting this answer formally (green button)!
--SA

Sergey Alexandrovich Kryukov 16-Aug-12 13:02pm

This is a valid important point, a 5.
--SA

Wendelius 16-Aug-12 16:15pm

Thanks SA.

Espen Harlinn 19-Aug-12 9:28am

5'ed!

Wendelius 21-Aug-12 1:00am

Thanks Espen :)

Points to be considered at the time of Creating a Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Points to be considered at the time of Creating a Table

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us