Collections:
PHP MSSQL - Dropping an Existing Table
PHP MSSQL - How To Drop an Existing Table?
✍: Guest
If you need to delete a table created before, you can run the DROP TABLE SQL statement using the mssql_query() function, as shown in the following sample script:
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); # dropping an existing table $sql = "DROP TABLE fyi_links"; $res = mssql_query($sql,$con); print("Table fyi_links dropped.\n"); # creating a new table $sql = "CREATE TABLE fyi_links (" . " id INT NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)" . ", counts INT" . ", time DATETIME" . ")"; $res = mssql_query($sql,$con); print("Table fyi_links created.\n"); mssql_close($con); ?>
If you run this script, "fyi_links" will be dropped and created again:
Table fyi_links dropped. Table fyi_links created.
⇒ PHP MSSQL - Inserting Data into an Existing Table
⇐ PHP MSSQL - Creating a New Table
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-03-07, 1305🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...