General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Invalid database table name error
I am using a varible that contains the name of a table. Using the drop table command, I get the an error stating 'invalid database table name'. Isn't it possible to delete table based on variable names? Here is the code:
&&cmdcreatetable this create random name table
ranvar = sys(2015)
.ranvar = ranvar
SELECT test FROM employee!employee into table (ranvar)
&&cmddeletetable this is suppose to delete random name table
ranvar = .ranvar
drop table (ranvar+'.dbf')
Thanks
Nick Patel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only