Skip to content

Create table statement

Tako Lee edited this page Feb 16, 2014 · 25 revisions
  • Fields fit into one line

    • Fields in the same line as CREATE TABLE keyword

      CREATE TABLE dbo.mytable ( low int, high int, myavg AS (low + high)/2 ) ;
    • Fields in new line, indent by 1 or n

      CREATE TABLE dbo.mytable 
        ( low int, high int, myavg AS (low + high)/2 ) ;
  • Stacked fields

    • Fields in the same line as CREATE TABLE keyword *Comma in the end of line

      ```SQL
      CREATE TABLE dbo.mytable ( low int, 
                                 high int, 
                                 myavg AS (low + high)/2 ) ;
      ```
      
Clone this wiki locally