SQL Server: table

A new table is created with one of the following two statements:

• The create table
• select into

A (non-tempoarary) table is removed with the drop table statement.

The sys.tables view lists the tables and can be used to query for tables that meet certain characteristics such as their name, or which schema they belong to.

Alternatively, the stored procedure sp_tables might be used.

In order to show column names of a given table or to search for columns with certain characteristics, the view sys.columns or stored procedure sp_columns might help.

table is also a T-SQL data type.

parent_and_child_tables.pl is a Perl script that shows a table's primary and foreign key.

SQL Server: Table valued functions

The name of a table can be renamed with sp_rename