Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag CREATE TABLE Rss

   Items 1 to 6 of 6   
 

Legal/illegal characters in table name

By Honey Badger 2015/04/08 | Category: create table
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 reads

Create Table FAILED!?

By Steve Knox 2014/12/30 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,238 reads

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type  Read more...
By Mitesh Oswal 2014/04/18 | Source: SQLServerCentral.com | Category: drop table
Rating: |  Discuss |   Briefcase | 1,140 reads

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.  Read more...
By Additional Articles 2013/07/01 | Source: SimpleTalk | Category: syntax
Rating:  Rate this |   Briefcase | 3,945 reads

Recreate a temporary table from TempDB

This Script can be used to pick out a temporary table from tempDB you might want to Check and drop the table before you create it just in case , but I Haven't included it here  Read more...
By Tristan Cook 2013/01/15 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,116 reads

Generate DDL script to create table and all constraints

Generate all DDL statements for a given table (Create Table, PK, FK, Check Constraints, Defaults)  Read more...
By VPSD Gupta 2012/04/03 | Source: SQLServerCentral.com | Category: create ddl sql statements
Rating: |  Discuss |   Briefcase | 2,336 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (2)    
create check constraints (1)    
create ddl sql statements (1)    
create default constraints (1)    
create fks sql statement (1)    
create pk sql statement (1)    
drop table (1)    
dynamic sql (1)    
error messages (1)    
syntax (1)    
tempdb (1)