Collections:
PHP MSSQL - Creating a New Table
PHP MSSQL - How To Create a New Table?
✍: Guest
If you want to create a table in the SQL Server database, you can run the CREATE 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); # 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); if (!$res) { print("Table creation failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { print("Table fyi_links created.\n"); } mssql_close($con); ?>
If you run this script for the first time and there is no existing table called fyi_links in the database, you will get:
Table fyi_links created.
If you run it again, you will get:
Table creation failed with error: There is already an object named 'fyi_links' in the database.
⇒ PHP MSSQL - Dropping an Existing Table
⇐ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-03-07, 1242🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...