MSSQL Tutorial Table 47 codes

1 A global temporary tables name begins with ##

2 A script that creates a global temporary table of random numbers

3 A script that uses a local temporary table instead of a derived table

4 A statement that adds a new check constraint

5 A statement that adds a new column

6 A statement that changes the data type of a column

7 A statement that creates a table with column attributes

8 A statement that drops a column

9 ALTER data size for a COLUMN

10 Alter table to add a constraint based on IN function

11 Alter table to add column

12 Alter table to drop a column

13 Altering a Table

14 Ambiguous column name during table join

15 Benchmarking the TRUNCATE and Delete

16 Change the length of the emp_name column in the employee table from varchar(30) to varchar(50)

17 Check table existance before dropping

18 CLUSTERED column

19 Column name with or without a table alias

20 Computational column

21 Computed columns are (by default) virtual columns not physically stored in the table

22 Create a computed column

23 Create a Table Index

24 Creating a Computed Column in alter table command

25 Creating a Local Temporary Table with a SELECT INTO

26 Creating a Table with Duplicate Rows

27 Designating a Columns Collation

28 Drop column syntax

29 Each declarative integrity constraint can be removed using the DROP clause of the ALTER TABLE statement

30 Expanded nvarchar(20) to nvarchar(300)

31 Local temporary Table

32 PRIMARY KEY column

33 Query two tables with column in common

34 Reference column with table name

35 Reporting Table Information

36 SELECT INTO a temporary table

37 Table alias during table join

38 Table Creation Script for Parent and Child with FOREIGN KEY Constraint and INSTEAD OF Trigger

39 Temporary Tables

40 The basic syntax of the ALTER TABLE statement

41 The basic syntax of the CREATE TABLE statement

42 The DROP COLUMN clause provides the ability to drop an existing column of the table

43 The syntax of the DROP TABLE statement

44 TRUNCATE TABLE removes all of the records in a table without logging a transaction

45 Use ALTER TABLE statement to define the foreign key of a table

46 Use ALTER TABLE statement to define the primary key

47 Using a Temporary Table to Communicate with an EXEC()