Entry

Database: Microsoft SQLserver: SQL:Database:Operation:Create: Simple: How create 1 table, using SQL?

Dec 22nd, 2003 12:56
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 22 December 2003 - 09:52 pm -------------------

Database: Microsoft SQLserver: SQL:Database:Operation:Create: Simple: 
How create 1 table, using SQL?

---

For example, you want to create
one table with person information

---

Steps: Overview:

 1. -Design your tables

      Table 1:

      ---

      Table 'Person'
      -------------------------
      NAME
      -------------------------
      john doe
      vanessa beau
      -------------------------

 2. -Create your tables

     1. Creating this table 1 in SQL

        ---

      CREATE TABLE Person (
       Name VARCHAR( 50 ) NOT NULL,
      );

---

More in general:

---

 CREATE TABLE <Tablename> (
  <Columnname1> <Datatype1> [NOT NULL],
  <Columnname2> <Datatype12> [NOT NULL],
  ...
  <Columnnamelast> <Datatypelast> [NOT NULL]
 );

---
---

Internet: see also:

---

Database: Microsoft SQL server: SQL: Database:Operation: Create: How 
to create a database,using SQL?
http://www.faqts.com/knowledge_base/view.phtml/aid/27565/fid/147

----------------------------------------------------------------------