:
ALTER TABLE table
{[ALTER COLUMN
column_name {new_data_type [(precision [, scale])]
[NULL | NOT NULL]
| {ADD | DROP} ROWGUIDCOL}]
|ADD
{[<column_definition> ]
column_name AS computed_column_expression}[,...n]
[WITH CHECK | WITH NOCHECK] ADD
{<table_contraint>}[...n]
|DROP
[CONSTRAINT] contraint_name | COLUMN column }[....n]
{CHECK | NOCHECK} CONSTRAINT {ALL | constraint_name[,...n]}
{ENABLE | DISABLE} TRIGGER {ALL | trigger_name[....n]}}
ALTER TABLE , , :
ALTERCOLUMN, . (new_data_type), (precision) (scale). , NULL. .
- ADD. , , CREATETABLE.
.
- DROP. (COLUMN), . , :
1 , ;
2 , ;
3 , ;
4 , ;
.
, . DISABLE TRIGER - . - ENABLE TRIGGER. - ALL.
.
Transact SQL DROP TABLE. , .
41 T-SQL. INSERT SELECTINTO.
INSERT .
INSERT [INTO]
{ table_name }
{ [(column_list[,...n])]
{ VALUES ({ DEFAULT | NULL | expression }[....n])
| derived_table | execute_statement } } | DEFAULT VALUES
INTO - INSERT , , .
Table_name - , .
column_list - , . , , .
VALUES - , .
derived_table - SELECT, , .
execute_statement. - , SELECT, EXECUTE .
DEFAULT VALUES - .
, , , SELECT...INTO. SELECT...INTO . SELECT...INTO :
SELECT {column_name [[AS] column_alias [...n]}
INTO new_table FROM {source_table [..n]
<select_options>]
new_table - , .
select_options - select