In SQLite, you can drop a table with the DROP TABLE statement.
You can optionally add the IF EXISTS clause to suppress any errors that might occur if the table doesn’t exist.
Also, if the table is referenced by a foreign key, there are a few things to be aware of.
Continue readingIn SQL, if you want to remove a column from a table, you need to use the ALTER TABLE statement with the DROP COLUMN clause.
That removes the column and all its data.
Continue readingIn this SQL tutorial for beginners, you will create your own database, insert data into that database, and then run queries against that database.
This SQL tutorial will get you running SQL queries in no time!
Continue readingThis article provides a quick example of renaming a table in SQL.
Most of the major RDBMSs allow you to rename a column with the ALTER TABLE statement. SQL Server is an exception.
If you have a partitioned table or index in SQL Server, and you want to determine which partition a given value would be mapped to, you can do this nice and quickly with the $PARTITION system function.
All you need to know is the name of the partition function (and of course, the value you’re interested in).
Continue readingIf you’ve previously created a partitioned table in SQL Server, and you now want to know how many rows are being stored in each partition, here are three queries you can use.
In particular, you can:
sys.dm_db_partition_stats viewsys.partitions view$PARTITION function in a queryBelow are examples of all three.
Continue readingThe SQL CREATE TABLE ... AS SELECT statement enables you to insert the results of a query into a new table.
The SQL SELECT INTO statement is a Sybase extension that can be used to insert the results of a query into a table (or a variable, depending on the DBMS).
The SQL INSERT statement is most commonly used to insert individual rows into a table.
But you can also insert the results of a query into a table. This means that you can insert multiple rows at once (as long as they’re returned by the query).
Continue readingSQL Server has the UPDATE() function that you can use within your DML triggers to check whether or not a specific column has been updated.
While this function only accepts one column, there’s nothing to stop you from including multiple UPDATE() clauses with AND or OR to test for multiple column updates.