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 4 of 4   
 

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,073 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,894 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,096 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,220 reads
   Items 1 to 4 of 4   
 
Tags
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)    
syntax (1)    
tempdb (1)