alter database pub2 on newdata = 3

alter database production on userdata1 = 10 log on dev = 2

alter database master on master = 1

Increases the amount the space allocated to a database

alter table ventas_dia add ord_num numeric (5,0) identity

Adds new columns; adds, changes or drop constraints, change constraints, partitions or unpartitions an existing table

Encloses a series of SQL statements so that control-of-flow language, such as if..else , can affect the performance of the whole group

Marks the starting point of a user-defined transaction

Causes an exit from a while loop, break is often activated by an if test

Writes all "dirty" pages (pages that have been updated since they were last written) to the database device

Deactivates a cursor

Marks the ending point of a user-defined transaction

Generates summary values that appear as additional rows in the query results

Causes the while loop to restart. continue is often activated by an if test

Creates a stored procedure that can take one or more user-suplied parameters

Specifies the domain of acceptable values for a particular column or for any column of a user-defined datatype

Creates a new collection of tables, views and permissions for a database user

Creates new tables and optional integrity constraints

Crea un "trigger" (interruptor o condicional de accion inmediata), es un tipo de procedimiento almacenado a menudo usado para forzar la integridad de las "constraints" (reglas de si o si). Un interruptor se ejecuta automaticamete cuando un usuario intenta hacer una modificacion sobre los datos especifica sobre una tabla determinada.

Creates a trigger, a type of stored procedure often used for enforcing integrity constraints. A trigger executes automatically when a user attempts a specified data modification statement on a specified table

Creates a view, which is an alternative way of looking at the data in one or more tables

checkdb [( database_name [, skip_ncindex}) |

checkalloc [( database_name [, fix |  nofix])] |

tablealloc ({ table_name  |  table_id }
     [, {full | optimized | fast | null}
     [, fix |  nofix]]) |

indexalloc ({ table_name  |  table_id }, index_id
     [, {full | optimized | fast | null}
     [, fix |  nofix]]) |

checkcatalog [( database_name )] |

dbrepair ( database_name , dropdb) |

reindex ({ table_name  |  table_id }) |

fix_text ({ table_name  |  table_id }) }

dbcc tablealloc(editores, null, nofix)

dbcc checktable(ventas)

dbcc indexalloc ("libros..autor-titulo", 2, full)

dbcc dbrepair(libros, dropdb)

dbcc reindex(titulos)

dbcc fix_text(textest)

Database Consistency Checker ( dbcc ) checks the logical and physical consistency of a database. dbcc should be used regularly as a periodic check or if damage is suspected

Makes a cursor inaccesible and releases all memory resources committed to that cursor

Declares the name and type of a local variables for a batch or procedure. local variables are assigned values with a select statement

Defines a cursor

Removes rows from a table

Makes a physical device or file usable by SQL server. (It is not necessary to use disk init on the master device, which is initialized by the sybinit installation program.)

Creates a software mirror that inmediately takes over when the primary devices fails. You can mirror the master device, devices that store data, and devices that store transaction logs; you cannot mirror dump devices

Rebuilds the master database's sysusages and sysdatabaes system tables from information contained in sysdevices . Use disk refit after disk reinit as part of the procedure to restore the master database

Rebuilds the master database's sysdevices system table. Use disk reinit as part of the procedure to restore the master database

Reenables disk mirroring after it is stopped by failure of a mirrored device or temporarily disabled by the disk unmirror command

Disables either the original device or its mirror, allowing hardware maintenance or the changing of a hardware device

Removes one or more databases from a SQL Server

Removes a user-defined default

Removes an index from a table in the current database

Removes user-defined stored procedures

Removes a user-defined rule

Removes a table definition and all of its data, indexes, triggers, and permission specifications from the database

Removes a trigger

Removes one or more views from the current database

Makes a backup copy of the entire database, including the transaction log, in a form that can be read in with load database

Makes a copy of transaction log and removes the inactive portion.

no_truncate copies the log without truncating it. Use when the databse is inaccesible after device failure

truncate_only truncates the log without copying it. Use for databses without separating log segment and databases for which you do not need an up_to_date dump

no_log truncates a log without copying it and without logging the event. Use only as a last resort , when your usual method of dumping the transaction log fails because of insufficient log space

Runs a system procedure or a user-defined stored procedure

Return a row or a set of rows from a cursor result set

Branches to a user-defined label

Assign permissions to users

Used in select statements to divide a table into groups

Imposes conditions on the execution of a SQL statement. The statement following an if keyword and its condition is executed if the condition is satisfied (when the logical expression returns "true"). The optional else keyword introduces an alternate SQL statement that executes when the if condition is not satisfied (when the expression returns "false")

Adds new rows to a table or view

Kills a process

Loads a backup copy of a user database, including its tranasaction log. The listonly and headeronly options display information about the dump files without loading them

Loads a backup copy of the transaction log. The listonly and headeronly options display information about the dump files without loading them

Marks a database, available for public use after a normal load sequence and, if needed, upgrades a loaded database and transaction log dumps to the current version of SQL server

Opens a cursor for proccessing

Returns query results in the specified column(s) in sorted order

Used by DB-Library in a two-phase commit application to see if a server is prepared to commit a transaction

Prints a user-defined message on the user's screen

Prints a user-defined error message on the user's screen and sets a system flag to record that an error condition has ocurred

Reads text and image values, starting from a specified offset and reading a specified number of bytes or characters

The reconfigure command currently has no effect; it is included to allow existing scripts to run without modification. In previous releases, reconfigure was required after the sp_configure system procedure to implemnt new configuration parameter settings

Exits from a batch or procedure unconditionally, optionally providing a return status. statements following return are not executed

Revokes permissions from users

Rolls a user-defined transaction back to the last savepoint inside the transaction or to the beginning of the transaction

Rolls back the work done in a trigger, including the update that caused the trigger to fire, and issues an optional raiserror statement

Sets a savepoint within a transaction

declare shared_crsr cursor for select title, title_id from titles shared where title_id like "BU%"

select * from publishers

Retrieve rows from database objects

Sets SQL Server query-processing options for the duration of the user's work session. Can be used to set some options inside a trigger or stored procedure

Shuts down SQL Server or a Backup server. This command can be issued only by a System Administrator

Remove all rows from a table

Return a single result set that combines the results of two or more queries. Duplicate rows are eliminated from the result set unless the all keyword is specified

Changes data in existing rows, either by adding data or by modifying existing data

Updates information about the distribution of key values in specified indexes

Specifies the database with which you want to work

Specifies a specific time, a time interval, or an event for the execution of a statement block, stored procedure, or transaction

Sets the search conditions in a select, insert, update or delete statement. (Joins and subqueries are specified in the search conditions: see the "Joins" and "Subqueries" sections for full details)

Sets a condition for the repeated execution of a statement or statement block. The statement(s) are executed repeatedly as long as the specified condition is true

Permit non-logged, interactive updating of an existing text or image column