Hi,
In create table statements we use database_name.table_name.
Eg :
create table my_database.test_table(sno int ....)
What is the meaning of this ? Is that, the table is created in the specified database_name ?
Please clarify.
Thanks,
SamOf course ... But the correct form include owner information as below ...
CREATE TABLE DBName.OwnerName.TableName (ID int)
Bye.|||Can't I give
create table db_name.table_name
( omitting the owner name ) ?|||No. You can use CREATE TABLE db_name..table_name.
The owner will default to whoever is running the CREATE TABLE statement. If the are db_owner, it will default to dbo.
Showing posts with label database_name. Show all posts
Showing posts with label database_name. Show all posts
Sunday, February 19, 2012
Subscribe to:
Posts (Atom)